Conditional formatting problems

Igorod

New member
Joined
Oct 23, 2012
Messages
2
Reaction score
0
Points
0
Location
York, Pennsylvania, United States
I have a spreadsheet with values in column A reflecting a ticket number, values filled out in columns B through H, and then responses that get completed after talking to a user in column I. I'd like to set up conditional formatting so that the cell in column I turns red, if the cell in column I is blank and the respective cell in column A is filled out.

A B-H I
12345 Contacted user.(not red)
12345 (red)
(not red)
 
Setup new rule and use formula below. Don't for get to set the fill color to red on the format


=AND(A1>0,I1="")
 
Back
Top