Help with date formula and colour change

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.
 
I

isabelle

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 :
 
C

Claus Busch

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.
 
S

ss

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with IF statement, too many arguements 1
Help with formula 1
Is this formula the problem? 7
Conditional formating 4
I cant work out what the error is. 3
Excel Formula Help 1
Can't change the cell back to blank when there is a date in it. 0
Count cells containing specific text when adjacent cell contains datewithin a range... 4

Top