Aug 15 2022 02:48 AM
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!
Aug 15 2022 03:27 AM
SolutionTry using =$BQ4=F$3 and apply to =$F4:$BP4
Then use the Format Painter to copy the formatting to F6:BP6 etc.
Aug 15 2022 04:17 AM
Aug 15 2022 04:24 AM
Aug 15 2022 04:36 AM
Aug 15 2022 06:03 AM
Comma 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.
Aug 15 2022 06:19 AM
Aug 15 2022 06:30 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Aug 15 2022 10:49 AM
Here is the workbook with the modified rule for lunch breaks.
Aug 15 2022 10:54 PM
Aug 15 2022 03:27 AM
SolutionTry using =$BQ4=F$3 and apply to =$F4:$BP4
Then use the Format Painter to copy the formatting to F6:BP6 etc.