Excel 2003 formula
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.
|
Quote:
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. |
All times are GMT +1. The time now is 03:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com