COlor Coding specified time frames
I am attemtpting to use validation with date function. Example: I have a
booked date and a specimen date. I want the cell to turn a specific color if the booked date and specimen date is 0-1 days, another color for 2-3 days, etc. Is this possible? I can apply conditional formating to a date just one day greater than my booked date. But that is as far as I can get with the cell coloring. |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com