Conditional formatting of a cell if another cell is blank

Closed
Ant104 Posts 4 Registration date Wednesday November 6, 2013 Status Member Last seen November 6, 2013 - Nov 6, 2013 at 05:24 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2013 at 01:42 AM
Hello, All
i am challenged in resolving the following problem I have and am hopefull that someone can help

in Column E I have specific text "tier 2" or "Tier 1" I would like to format the color column L if Column E = Tier 2 and the value in the corresponding cell in column L is blank.

below a example
Col E = tier 2 and Col L is blank then the cell for Col L must turn red
Col E = tier 1 and Col L is blank then stay unformatted.

any suggestions would be great and thank you in advance.

Hi All
i have entered the below conditional format (=E24="Indirect: 2-Tier") into cells L24 ~ 30 to test.

L24 is blank and E24= "Indirect: 2-Tier" and with the below formula the formatting works fine.

however in a cell L26 I do have a value entered and E26 =Indirect: 2-Tier and the formatting still works, I would like the cell to remain unchanged.

any suggestion on a formula that will help to overcome this?



4 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 6, 2013 at 08:02 AM
I woner whether conditiona formattsing cell and critiera cell can eb same


select M2 clilck home-conditoan formatting-manage rules-new rule-use a formula tol determibe.........-, below the snmall window tregardixng formula type the formula
=and(E2="tier 2",L2="")
and then do whatever formal lyou want.
\
copy M2 down pastespecial -format
0