Conditional formatting in one column based on the result of another

[mra1984]

If you see attached, PSF tab... where it says warning column...

If the warning says below contract then I would like to format the 'Net CV' column in the same way i.e. the number orange and white as well
If the warning says penalty then I would like to format the 'Net CV' column in the same way i.e. the number red and white as well

Many thanks in advance!!

Matt

[Sam Capricci]

ok, see attached.

[mra1984]

This doesn't work for me, when I apply to the whole sheet, the wrong values are being highlighted...

[Pete_UK]

You didn't say you wanted it for the whole row. See attached.

Hope this helps.

Pete

[Pete_UK]

I've set this up for you in the attached file. There was no need to start a new thread, though.

Hope this helps.

Pete

[Sam Capricci]

sorry, mine pointed to the wrong column, try this one instead...

[Sam Capricci]

BTW, not sure whose post you are addressing nor what exactly is wrong with either mine or Pete's beside i had formatted the wrong column.

EDIT: didn't understand you wanted the whole row.
if that is the case, good catch Pete.

[mra1984]

Thanks now sorted