Forum Discussion
Solved
Excel Conditional formatting
I want a date which less than another date to be highlighted. Each date neither of which is todays date, will change with the passage of time.
Do I use formatting or Conditional formatting
11 Replies
- Conditional formatting should do it. Otherwise you're talking of manually keeping it up-to-date. If you're looking for help in establishing the rule for conditional formatting, come back and ask that, ideally with a sample workbook.
- Mathetes thanks for yor response
I have tried Condition Formatting using Highlíght Cell Rules, Less than without success.
I have a data base of building material costs I want to keep tract on
those out of date by moving todays date back by various time periods.
Todays Date 3.11.21
Move todays backwords by months 2 = 60 Days 4.9.21
Backward movement may change with market conditions
If Enqiry date is more than red date above, Show no background colour
If Enqiry date is less than red date above, Show it with red background
Enquiry date which will change as it is backward looking 3.10.21
I am a rookie wíth computers, so am not sure how to attached a typical spread sheet.- Use the full Text editor option (down below the dialog box that opens when you click on "Reply") and drag and drop your file to the area set aside for that purpose.
