Thread: Conditional Formatting - If cell blank on sheet 2 i want another cell on sheet 1 red

Haven't posted in a long time...but here's my latest problem

I have a workbook with two sheets (sheet1 and sheet2)

On sheet 2, column A, row 1 i have dates:
7/1/11
7/2/11
7/3/11
etc
etc

all the way down to 12/31/11


then on sheet 2, column B, i have am placing either the DATE we receive information for that date...for example, a client sends us their 7/1/11 information on 7/2/11, so the box to the right of 7/1/11 would say 7/2/11...make sense?

however, if we dont receive anything for that client's date, i want initials put in the box proving nothing was sent

so if on 7/3/11 we didnt receive anything, i would put BC in the box to the right

my problem is though, if there is no date or no initials in the box to the right, i then want a corresponding box on sheet 1 to fill in RED

if there is a date or initials in the box to the right, i want the corresponding box on sheet 1 to show up w/ those initials or date


any assistance is great

thanks


ive attached an example

See updated example.


Regards

You're welcome. Thanks for the rep.

It always helps if there's a sample workbook to look at ;-)

You're one of the few, in my recent experience, that has provided one without prompting.

Regards