Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Formatting query
Hi all,
I need to place conditions on a spreadsheet dealing with dates. In a column I have dates eg 28 Aug 07, 15 May 07, 20 Jun 08 etc Lets say they are in cells B3, B4 and B5 respectively. At cell A1 there is a date =TODAY() In the B column I have placed conditional formatting as Cell Value Is: Equal or greater than $A$1 - it returns a cell coloured RED I'm at a loss to place a value in for those dates between Cell A and those in Column B from day 1 to day 90 (ie within 3 months) to return a colour of Yellow Hope you can understand my query, Cheers, Pete. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional sum query | Excel Worksheet Functions | |||
Conditional formatting query | Excel Worksheet Functions | |||
Conditional Query | Excel Discussion (Misc queries) | |||
Conditional MS Query | Excel Worksheet Functions | |||
How to preserve conditional formatting on a web query table result | Excel Discussion (Misc queries) |