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
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.
Related:
- Conditional formatting or VB
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Vb select case - Guide
- Vb net round - Guide
- Formatting usb mac - Guide
1 response
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Apr 20, 2010 at 04:20 AM
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
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