Hi
I have the following data on a sheet. It is basically a calendar that shows a persons days off.
Role 0 are fixed days off people. Role 1 is to be ignored.
I want a conditional formatting to be true when the following are satisfied:
1. Column B = 0
2. If the day (Row 1) for the corresponding date is TRUE in Columns C to I.
I can't figure out what formula I need to put into the conditional formatting.
The columns extend beyond Column W up to the last day of the year (so 365/366 columns in total).
I've placed X in the cells that I want to colour (there won't actually be any data in the cells and the X's are just to clarify the cells which will be true in the conditional format).
I hope I've worded this clearly.
Thanks
Liam
<tbody>
</tbody>
I have the following data on a sheet. It is basically a calendar that shows a persons days off.
Role 0 are fixed days off people. Role 1 is to be ignored.
I want a conditional formatting to be true when the following are satisfied:
1. Column B = 0
2. If the day (Row 1) for the corresponding date is TRUE in Columns C to I.
I can't figure out what formula I need to put into the conditional formatting.
The columns extend beyond Column W up to the last day of the year (so 365/366 columns in total).
I've placed X in the cells that I want to colour (there won't actually be any data in the cells and the X's are just to clarify the cells which will be true in the conditional format).
I hope I've worded this clearly.
Thanks
Liam
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |
1 | Name | Role | Mo | Tu | We | Th | Fr | Sa | Su | Mo | Tu | We | Th | Fr | Sa | Su | Mo | Tu | We | Th | Fr | Sa | Su |
2 | 1/1 | 2/1 | 3/1 | 4/1 | 5/1 | 6/1 | 7/1 | 8/1 | 9/1 | 10/1 | 11/1 | 12/1 | 13/1 | 14/1 | |||||||||
3 | Joe Bloggs | 0 | TRUE | TRUE | TRUE | x | x | x | x | x | x | ||||||||||||
4 | John Smith | 1 | |||||||||||||||||||||
5 | Alan Jones | 0 | TRUE | TRUE | TRUE | x | x | x | x | x | x | ||||||||||||
6 | John Doe | 0 | TRUE | TRUE | TRUE | x | x | x | x | x | x | ||||||||||||
7 | Mary King | 1 | |||||||||||||||||||||
8 | James May | 0 | TRUE | TRUE | TRUE | TRUE | x | x | x | x | x | x | x | x |
<tbody>
</tbody>