![]() |
conditional Formatting based on cell formatting
Hello,
I wanted to know if it was possible to do the following and if yes how. I have a cell A1 (for example) that has a date (01/10/2006) which is bold black. This is a deadline date therefore not the actual date. When I get the actual date I change the formatting to bold Green/Red (depending if I was on time or late). when the date is bold black, I would like a conditional formatting to look at the date vs today and if date < today then I would like to format the background of this cell RED. How can I do this ? Thanks |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com