Previous Topic Next Topic

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 response

Answer 1 / 1
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses