Forum Discussion
tbigrigg
Aug 06, 2024Copper Contributor
Conditional Formatting a cell to change color when a certain date is reached
I'm wanting to set up conditional formatting so an entire cell row changes color when a certain date is reached. I've been able to change a single cell but I'm having trouble doing the row, and it's been years since I've really had to use EX
The cells range A-N, and it starts on row 3, so A3 is the 98 field. I would like the entire row to turn red if the date in K3 (this is the 6/4/2025 field) within 30 days, of 6/4/2025, and to turn yellow if this same field is within 60 days.
Thanks for any help.
98 | Hipot (0-120 kVAC) | High Voltage Inc. | 112 | X | TD | Yes | 1 | 1 | 6/4/2024 | 6/4/2025 | Test Lab |
|
1 Reply
- Riny_van_EekelenPlatinum Contributor
tbigrigg Perhaps the attached example helps you on your way. Assuming European style dates here, by the way.