- Registration date
- Monday August 16, 2010
- Last seen
- May 13, 2021
Klor, Good morning.
Your request is very superficial.
Missing data to help you effectively.
Suppose you want color cells B1:F1, IF A1 is not empty.
Try to do:
Select cells you want color: B1:F1
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =$A$1<>""
Choose ORANGE as fill format
Please, tell us if it works for you.
Belo Horizonte, Brasil.