The following works for me
Select the first cell (calculated or not - it makes no difference) for the
conditional formatting

Format
Conditional Formatting
Condition 1
<Cell Value between =now()-1 and =now()+14
format to required green
Add condition 2
<Cell Value between =now()+15 and =now()+30
format to required yellow
Add condition 3
<Cell Value greater than =now()+30
format to required red

(Note that in the conditions there are no spaces)

OK
Click on FORMAT PAINTER
Highlight all the cells the formatting is to apply to

Hope this solves your problem

Don C


"Corey" wrote:

Thanks for the reply.
I have entered as you suggested, but i do not get ANY shading at all??


--
Regards

Corey

"daddylonglegs"
wrote in message
news:daddylonglegs.2bs6qv_1154301011.7433@excelfor um-nospam.com...

The order in which you apply the conditions is important. You can use
"formula is" but "cell value is" works fine too. Use something like
this

condition 1
"cell value is" Greater than =TODAY()+30
red format

condition 2
"cell value is" Greater than =TODAY()+14
yellow format

condition 3
"cell value is" Greater than =TODAY()
green format


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=566469