Previous Topic Next Topic

Conditional formatting if a cell is blank and other has value

Closed
Ant104
Posts
4
Registration date
Wednesday November 6, 2013
Status
Member
Last seen
November 6, 2013
 - Nov 6, 2013 at 03:59 AM
Hello,
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.

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.