Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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


  #2   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default Conditional Formatting in Excel 2007

On Sep 30, 4:56*pm, Scott wrote:
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


In the first condition Formula is: =$A$4$I$16+10 Format Pattern
blue
in the second condition Formula is =$A$4$I$16+5 Format Pattern
yellow
In the third condition Formula is =$A$4$I$16 Format Pattern
red


or you can use Cell Value is greater than $K$16+10 etc
etc
greater than $K
$16+5
greater than $K$16
ed
Reply
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 06:05 PM
Conditional Formatting in Excel 2007 JOHN HARRIS Excel Worksheet Functions 1 November 14th 07 08: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 11:37 PM.

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

About Us

"It's about Microsoft Excel"