LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default Conditional Formatting in Excel 2007


Conditional Format Help

Due date in cell I16

Date in cell A4 shows when something was last done.

I want to make a conditional format in cell A4 if the cell value of A4:

1. Is ten days or greater of I16 to make the cell blue
2. Is between 5 to 9 days of I16 to make the cell yellow
3. Is between I16 and 4 days of I16 to make the cell red

Thanks in advance


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting in Excel 2007 KiwiGail Excel Discussion (Misc queries) 1 July 29th 08 12:37 PM
Conditional formatting in Excel 2007 SalesBK New Users to Excel 3 May 16th 08 05:08 AM
Conditional Formatting Excel 2007 yelnocer Excel Worksheet Functions 1 March 15th 08 05:05 PM
Conditional Formatting in Excel 2007 JOHN HARRIS Excel Worksheet Functions 1 November 14th 07 07:11 PM
Conditional formatting in Excel 2007 Mike Tordoff Excel Discussion (Misc queries) 3 May 19th 07 07:20 AM


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"