conditional formating dates

akashawalker

New Member
Joined
May 2, 2013
Messages
16
Hi to all
I am trying to make a conditional formatting for dates.
i want to highlight rows for a period of 10 days from the today() date and the input cell dates.
if the cell in the date is out of this 10 days period it should change back to normal color.

all the help will be appreciated.

Akasha walker
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi ,

Give as much information as possible ; including worksheet cell / column / row references where ever possible.

What is the range reference over which this Conditional Formatting is to be applied ?

Will the value of 10 be specified in some worksheet cell , or can it be made a part of the CF formula ?
 
Upvote 0
Hi Naray below is my example.

A1
date logToday date
03-11-1707-11-17
05-11-17
03-10-17I just want to have marked
20-11-17dates 10 days less then today
21-11-17
25-10-1728-10-17=today()-10
19-10-17so just the dates between today and 28-10-2017
16-11-17should be highlighted.
26-11-17
28-11-17
12-10-17
14-11-17
20-11-17

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

akasha walker
 
Upvote 0
Hi ,

Suppose your data is in the range A2:A14 ; select this range , and in the Conditional Formatting formula box enter the formula :

=AND($A2 >= TODAY() - 10, $A2 <= TODAY())

Adjust the >= , <= signs to > , < in case you do not want this.

What this will do is , for the data you have posted , is colour the first two entries of November 3 and November 5.
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top