Conditional formatting or VB

Closed
Wout - Apr 20, 2010 at 01:58 AM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Apr 20, 2010 at 04:20 AM

I tried setting up the below conditions with COnditional formatting but this seems not to work. I tried with VB but do not have so much experience. Anybody can advise how to set up ?


I want to change the color of the cell under the following conditions.

today plus less then 14 days ( date =< TODAY plus 14 days) , cell must be green
today plus 14 days but less then 30 days ( TODAY plus 14 days >DATE<= TODAY +30 days), cell must turn orange
today plus 30 days or more (DATE > TODAY plus 30 days), cell must turn red

Hope somebody can help me out.

1 reply

kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 12
Apr 20, 2010 at 04:20 AM
try this,

condition 1
Cell Value Is Less than or equal to =TODAY()+14
(and select format pattern to green)

condition 2
Cell Value Is Less than or equal to =TODAY()+30
(and select format pattern to Orange)

condition 3
Cell Value Is Greater than =TODAY()+30
(and select format pattern to Red)


http://www.showpic.in.th/show.php?id=b39374af6a8a93c9925eacd5366d2ebe

kaiyasit phanmakorn
0