EASY cond format Date??

[Guest]

Hi,
Cell B2 is a date unlocked
Cell C3 TARGET DATE is locked:
=DATE(YEAR(B2),MONTH(B2)-6,DAY(B2))

I know where the cond formatting is etc but can't figure out the format for
I am trying to get the C3 cell to change colors by:
If the date is within 14 days before the target date in C3 changes to yellow
If the date is within 2 days before the target date in C3 changes to another
color
If the date is within TARGET Date or past in C3 changes to red

Also, if D3 is checked then C3 is hidden.
I work with MSAccess and haven't used excel much so I don't know how to put
this in the proper formats. If someone know of an example I can look at that.
Thanks!!

 

[Ron de Bruin]

You can use a formula in CF like this

=NOW()-B3<14

 

[Guest]

Sorry but I don't see how this answers my full question... I have no B3 cell
for one thing and the question has 4 different parts
I understand this

=NOW()-B3<14

But I don't understand how NOW()-C3<14 will not conflict with the other
parts of my question and I don't know the format.

If the date is within 14 days before the target date in C3 changes to yellow
If the date is within 2 days before the target date in C3 changes to orange
If the date is within TARGET Date or past in C3 changes to red
Also, if D3 is checked then C3 is hidden.

Please, could you be more detailed
Thanks!

 

[Ron de Bruin]

Hi lmv

OK try this

Condition1

=TODAY()-C3<=0
Red color

Condition2

=TODAY()-C3<=2
Orange color

Condition3
=TODAY()-C3<=14
Yellow color

 

[Guest]

Thanks for the response... since this C3 is a calculated date not a stored
date does that have anything to do with the situation.
I tried the formulas you gave and they doen't work nothing happens.

I really thought this was an easy question... I guess not.

 

[Ron de Bruin]

Working here

Send me a small test workbook PRIVATE with the formula and the CF conditions in the formula cell.
I look at it tomorrow after work then

 

[Guest]

ok I sent you a test.xl
(I also still need to know how to make the date become invisible when the
check is marked also) Thanks!!