Google Spreadsheet Post #1995
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-19-2015
post by Rushmore Bhaji:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification&hl=en#!category-topic/docs/spreadsheets/G9vyGBjS3v4
Conditional Format a single cell if others in same row are blank
I would like to apply conditional formatting to column A.
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification&hl=en#!category-topic/docs/spreadsheets/G9vyGBjS3v4
Conditional Format a single cell if others in same row are blank
I would like to apply conditional formatting to column A.
I would like the text to change colour in any cell in column A where cells B to M are empty within the same row.
The cells I am checking for emptiness will only ever contain a number or an 'x'.
I tried to use the function ISBLANK but cannot get this to work over a range, only on a single cell.
Is this possible?
TIA
----------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment