LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Conditional Formatting - due date

I need some help with Conditional Formatting, please.

I have a spreadsheet used to track data relating to reports prepared for
clients. Column F on each row contains the date the report is due. Column
G contains the actual date when the completed report is submitted.

I would like to add conditional formatting to Column F. I can manage the
first part, which would add yellow background to cells with dates within the
next 3 days and red background to cells where the report is due today or
overdue.

However, the part I am stumped on is: I would like to have no background
once any value is entered into column G. Once the report has been
submitted, there is no longer any need to have color alerts, and it is not
helpful to have a bunch of red cells where the report has already been
submitted.
 
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 date ranges arkmpr Excel Worksheet Functions 1 January 19th 07 08:24 PM
WEEKDAY in Conditional Formatting? Ken Excel Worksheet Functions 3 January 18th 07 03:24 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Conditional Formatting Date Humpy New Users to Excel 4 February 25th 06 10:44 AM
Conditional Formatting (Date vs Number) [email protected] Excel Discussion (Misc queries) 7 December 20th 04 10:23 PM


All times are GMT +1. The time now is 07:44 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"