Forum Discussion
Solved
Copy/Extend/Duplicate Conditional Formatting
Hi, I'm doing a Schedule file and I want to apply a certain color to a certain cell when there's a specific value. Ex. If you select to take your break at 08:00 that cell on the schedule will be ...
Try using =$BQ4=F$3 and apply to =$F4:$BP4
Then use the Format Painter to copy the formatting to F6:BP6 etc.
Here is the workbook with the modified rule for lunch breaks.
Thanks a lot! Works like a charm 🙂