Help with date formula and colour change

  • Thread starter Thread starter ss
  • Start date Start date
S

ss

In cells D12 to D17 I have dates
In cell M5 I have another date.
What I want to do is if any of the dates in D12:D17 are more than the
cell in M5 then to change the colour to red.

How would I formulate this.
 
hi,

select your range (D12:D17) then go to Conditional Formatting
Use formula to determine....
and enter the next formula into the formula bar.
=$D12>$M$5
then choose the color

isabelle

Le 2014-07-16 14:21, ss a écrit :
 
Hi,

Am Wed, 16 Jul 2014 19:21:06 +0100 schrieb ss:
In cells D12 to D17 I have dates
In cell M5 I have another date.
What I want to do is if any of the dates in D12:D17 are more than the
cell in M5 then to change the colour to red.
Click to expand...

select D12:D17 => CF => Formula to determine...:
=D12>$M$5 and select a back color


Regards
Claus B.
 
Hi,

Am Wed, 16 Jul 2014 19:21:06 +0100 schrieb ss:


select D12:D17 => CF => Formula to determine...:
=D12>$M$5 and select a back color


Regards
Claus B.
Click to expand...

Ok got it sorted, thanks both for your help.
 
Back
Top