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.
98Hipot (0-120 kVAC)High Voltage Inc.112XTDYes116/4/20246/4/2025Test Lab
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 EXThe 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. 98Hipot (0-120 kVAC)High Voltage Inc.112XTDYes116/4/20246/4/2025Test Lab Read More
