Igorod
New member
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)
A B-H I
12345 Contacted user.(not red)
12345 (red)
(not red)