Hello,
I am attempting to format cells concerning dates. When a date is past due it is red and if its within the next week its green. I would like to enter data into the adjacent cell and have the cell with the dates change to a dark grey shade.
Example.xlsx
Thank you,
Bryce Carter
Your profile states 2003 yet your file (and CF) implies 2007 or later.
For your sake and those helping you please specify the correct version(s) in your profile as this helps to ensure valid advice... conditional formatting for ex. being one key area of difference from earlier versions.
Based on the sample add a pre-emptive rule (ie rule no.1) - use a formula driven solution - with cell F2 active add the following CF rule:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks