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" <(E-Mail Removed)> wrote in message
news220D99E-6044-4A2A-B71F-(E-Mail Removed)...
> 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