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.
Try using =$BQ4=F$3 and apply to =$F4:$BP4
Then use the Format Painter to copy the formatting to F6:BP6 etc.
Thanks! That's exactly what I was looking for and it works perfectly.
I forgot to mention the last column, which is lunch and instead of 15 mins it's 30 mins. Can you help me with that as well?
I forgot to mention the last column, which is lunch and instead of 15 mins it's 30 mins. Can you help me with that as well?
- Thanks again, I had to use =$BT4=OFFSET(F$3;0;-ISODD(COLUMN()))
Excel was giving me an error for using , instead of ;
This is working as well but only marks period like 08:00 to 08:30 but does not works if I choose 08:15 to 08:45Comma vs semicolon depends on your system settings.
The cells in F3:BP3 only have 8:00, 8:30, 9:00 etc.
If you want to handle 8:15, 8:45 etc, unmerge those cells and fill the empty cells with 8:15, 8:45 etc.