Quote:
Originally Posted by Henzoo
Please give the formula for: If a cell in a row in column G,K, and L has data entered, then the corresponding cell in that row in Column A will highlight.
|
Hi
Henzoo, Good Afternoon.
Try to use
Conditional Format
a) Select all Column A
b) At a Conditional Format Menu
Rule: Use formula-- =E(G1<"",K1<"",L1<"")
Choose some color. e.g. BLUE
OK
Now try to fill any combination of G,K,L cells to observe what happen at an A cell corresponding.
Tell us if it worked for you.
Have a nice day.