ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2003 formula (https://www.excelbanter.com/excel-worksheet-functions/448648-excel-2003-formula.html)

Henzoo

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.

Mazzaropi

Quote:

Originally Posted by Henzoo (Post 1611400)
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.


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com