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