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 filled with a color.
Formula:="$BQ$4="08:00" / Format / Applies to=$F$4
This has to be repeated for 12 different people, 3 times
I can't find a way to make this process simple rather than do it manually for each timeframe and person
Any ideas? Thanks!
Try using =$BQ4=F$3 and apply to =$F4:$BP4
Then use the Format Painter to copy the formatting to F6:BP6 etc.
9 Replies
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?
