conditional formatting help

[Baaron1]

Hi all,

I am seeking help with conditional formatting. I have a range of cells from A72:J162. I want to format each individual row in that range based on whether or not column H has an "x" in it. If column H="x" then I need it to format the whole row green. Thanks in advance!

 

[rs2k]

Try this formula in conditional formatting;

in A72 select conditional formatting, and choose formula is, then paste in this formula,

=IF($H72="x",TRUE)

Click format and then the pattern tab and choose your colour.

Apply(copy) this to the required range (A72:J162)

HTH
Colin

 

[lenze]

Select the whole range and use Formula Is

=$H72="x"

The CF is already an IF

lenze

 

[c_m_s_jr]

You shouldn't need the IF.

=$H72="x" should suffice.

 

[rs2k]

'The CF is already an IF' & 'You shouldn't need the IF'

Well I've learned something today, noted for future use...cheers chaps.