LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default 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
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 sum query dmorris1 Excel Worksheet Functions 1 November 7th 06 03:39 PM
Conditional formatting query oktc Excel Worksheet Functions 2 March 23rd 06 09:30 AM
Conditional Query jimbob Excel Discussion (Misc queries) 3 January 29th 06 10:08 PM
Conditional MS Query Dean Excel Worksheet Functions 1 January 10th 06 01:52 PM
How to preserve conditional formatting on a web query table result Simon L Excel Discussion (Misc queries) 9 February 26th 05 01:19 AM


All times are GMT +1. The time now is 06:52 AM.

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"