Excel conditional formatting

[MarkAK]

Hi,

I am having a problem with conditional formatting in Excel.

What I need to do is add a format that will highlight a whole row if the value in a particular column meets certain criteria.

(not the best explanation i feel, What I am trying to say is that if I type "cancelled" -for example -in a cell I need the whole row to the left to be formatted)

Thanks in advance

M...

[smurfy]

Sorry for the delay in replying here Mark, I've been away.

Not sure what Excel version you are using but this works in 97 & 2000.

Click on cell B1 in the row 1 and Format>Conditional Formatting...

Condition 1
Change "cell value is" to "formula is"
In formula box, type
=($A1="Cancelled")
Set your format.

Copy that cell and highlight the rest of the row cells and paste special = formats

Now repeat steps for subsequent rows.

[MarkAK]

Worked perfectly

|Thanks a lot. Sorry it took a whil to get back but I know you like to see results