Condition Formatting based on If Then

  • Thread starter Thread starter Kyle
  • Start date Start date
K

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
 
Format/Conditional formating

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

=F1 = "No", format, etc.
 
Back
Top