ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   COlor Coding specified time frames (https://www.excelbanter.com/excel-programming/414382-color-coding-specified-time-frames.html)

Kim[_2_]

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