Excel 2010 IF Statements and Conditional Formatting

Permabanned
Joined
10 Nov 2005
Posts
2,554
Hi guys,
just a quick one as it's been awhile since I've used IF statements and conditional formatting...
basically I want to use the key as pictured here to highlight and fill the F column accordingly based upon the key's fields.
2nk00us.png

I want the colours to be filled as per the key also.

Cheers!
 
Back
Top Bottom