Use Conditional Formatting or IF statement in Blank Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-204993%22%20slang%3D%22en-US%22%3EUse%20Conditional%20Formatting%20or%20IF%20statement%20in%20Blank%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-204993%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI%20have%20a%203x3%20table%20with%20dates%20in%20it%20and%20some%20area%20BLANK%3C%2FP%3E%3CP%3EI%20would%20like%20to%20use%20the%20formula%20ISBLANK(cell%23)%2C%20and%20Conditional%20Formatting%20to%20Auto%20WRITE%20the%20text%20Need%20a%20Date%20and%20Fill%20RED%20background.%3C%2FP%3E%3CP%3EWhat%20I'm%20receiving%20is%20an%20error%20about%20Circular%20Reference.%3C%2FP%3E%3CP%3EBasically%2C%20I%20want%20to%20identify%20'each'%20cell%20that%20is%20blank%20and%20write%20into%20that%20cell%20the%20message%20Need%20a%20Date%20until%20a%20Date%20is%20entered%20(see%20attached%20file).%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETom%20Petrik%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-204993%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

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