Condition Formatting based on If Then

[Kyle]

We are trying to format cell A1 based on the value of F1. For example:

If value of F1='LT" then A1:B1 should be green filled.
If value of F1 ='No' then A1:B1 should be red filled.
If value of F1='Complete' then A1:B1 should be grey.

It seems that Excel should be capable of this but I can't seem to find the
answer within help or on microsoft.com

 

[Sean Timmons]

Format/Conditional formating

Change drop down to Formula is:
enter:
=F1="LT" set format

=F1 = "No", format, etc.