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.