Forum Discussion
SammyShreds
Jan 07, 2022Copper Contributor
How to change the colour of a cell according to the text in a cell that preceeds it.
Hi, I'm looking to add a new quality of life feature to a rota tool I'm using at work to make it easier to see peoples availability. I work for a logistics company with many drivers all with varying ...
HansVogelaar
Jan 07, 2022MVP
If you want this to cross the weeks, remove the empty columns between the weeks. You can use an extra thick border between the weeks to distinguish them.
Select the entire range you want to format, say B10:AF23. B10 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=OR(AND(A10="L",B10="E"),AND(B10="L",C10="E"))
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then click OK again.