Saturday, December 19, 2015

yogi_Conditionally Format Cells Of Column A If Cells In Corresponding Rows Of Columns B Through M Are Blank

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. 

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