conditional formating

[Tyre]

can I use conditional formating to do the following:

in cell E2 (for example) I have a dropdown box with several choices, one of which is 'cancel'
I want to format the whole row in red IF the cell=cancel

I tried conditional formating, but cannot seem to apply it to the whole row....

ideas?

thanks

 

[Joe4]

Highlight the whole row when you set the conditional formatting. If using a formula, you may need to lock the column with a $ sign, i.e.

=$E2="Cancel"

Edit: Actually, I think if you are doing a whole row based on one column in that row, you need to use "Formula is" and the formula I provided above instead of "Cell Value is".

 

[Tyre]

perfect, thanks (I tried something like that but got the formula wrong)
thanks again