I need to do a Conditional Format that will check the date that I have set on
Sheet 1 Cell A3 compared to Sheet 2 Cell E1. If the Date in is before SH1,CA3
then Cell A1 on sheet 2 will have a red background.

Can I do this?

Thanks

Keith

You need to name the cell on Sheet1 and compare the name to cell E1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"KAnoe" wrote in message
...
I need to do a Conditional Format that will check the date that I have set
on
Sheet 1 Cell A3 compared to Sheet 2 Cell E1. If the Date in is before
SH1,CA3
then Cell A1 on sheet 2 will have a red background.

Can I do this?

Thanks

Keith