conditional format formula? help please

  • Thread starter Thread starter Geoff Brandt
  • Start date Start date
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
 
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
 
Amazing what difference a "$" makes...Thanks!

-gb


Dan E said:
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
Click to expand...
Click to expand...
 
Back
Top