Conditional formatting for new excel on word

use formula

Assuming the dates starts at A2

for 2007, 2010 or 2013 excel version
Conditional Formatting

Highlight applicable range >>

Range you would like to apply the conditional formatting to - NOTE the first cell ie B2:G200 (row 2 - also will need to be used in the formula )


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=A2 < today() +30


Format… [Number, Font, Border, Fill] = orange
choose the format you would like to apply when the condition is true
OK >> OK

and for green
=A2 >= today()

and for red
=A2 < today()

put them in an order of
RED
ORANGE
GREEN

and stop if true

otherwise add a sample sheet here

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

you have the correct formulas
just add the stop if true - tick the box

now
the order should be
pink
orange
green

Yes its because the selection s for all the column and we start at row 2
so its one row out

change all the 2 to 1

OK - so then in the applies to range you put
D2:D1000

or whatever the number of rows will be

we will need to also modify the code to exclude cells with blank spaces

yes you can apply to column E
BUT what do you want in E

i have modified in attached

yes
click on the column to select it all
then click on the column you want to copy to
then Paste Special> format