G
Geoff Brandt
Folks,
I would like to format an entire row in my sheet based on the text in one
cell of each row. For example, when cell S33 equals "Complete", I'd like row
33 (or even just cells S1 to Snn) to assume a gray background.
Now I'm no stranger to Excel and routinely build mildly complex formulas and
arrays, but I can't seem to make this work in the conditional format dialog
box using the "Formula is" choice.
What am I missing? Anyone have a quick formula I can put in the dialog?
thanks,
-gb
I would like to format an entire row in my sheet based on the text in one
cell of each row. For example, when cell S33 equals "Complete", I'd like row
33 (or even just cells S1 to Snn) to assume a gray background.
Now I'm no stranger to Excel and routinely build mildly complex formulas and
arrays, but I can't seem to make this work in the conditional format dialog
box using the "Formula is" choice.
What am I missing? Anyone have a quick formula I can put in the dialog?
thanks,
-gb