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="")
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="")
Well I'll be darned, I was trying all kinds of crazy things and it was as simple as that. Works perfectly, thanks!
Bookmarks