conditional format formula? help please

[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

 

[Dan E]

Geoff,

Select Row 33
Format -> Conditional Formatting...
Formula is [=$S33="Complete"] (without brackets)
Set your format

If you wanted to apply this format to your entire sheet
Select all cells
Format -> Conditional Formatting...
Formula is [=$S1="Complete"] (without brackets)
Set your format

Then anytime a cell in column S contains the word "Comlete"
the entire row will recieve your selected format.

Dan E

 

[Geoff Brandt]

Amazing what difference a "$" makes...Thanks!

-gb

Geoff,

Select Row 33
Format -> Conditional Formatting...
Formula is [=$S33="Complete"] (without brackets)
Set your format

If you wanted to apply this format to your entire sheet
Select all cells
Format -> Conditional Formatting...
Formula is [=$S1="Complete"] (without brackets)
Set your format

Then anytime a cell in column S contains the word "Comlete"
the entire row will recieve your selected format.

Dan E

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