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
Related:
- Conditional formatting or VB
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Vb select case - Guide
- Vb editor download - Download - IDE
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