Jun 16 2018 10:05 PM
Hi there,
I have a 3x3 table with dates in it and some area BLANK
I would like to use the formula ISBLANK(cell#), and Conditional Formatting to Auto WRITE the text Need a Date and Fill RED background.
What I'm receiving is an error about Circular Reference.
Basically, I want to identify 'each' cell that is blank and write into that cell the message Need a Date until a Date is entered (see attached file).
Is this possible?
Tom Petrik