I need some help please with conditional formatting of some cells.
I have a chart with the days of the week across the top, dates just below and then a shift pattern below that. What I currently have is two conditional comments that work, to display the column with an ‘S’ in it (ie. Weekends) to fill red and a cell with a value of ‘D’ to colour green.
What I have been trying to do but just can’t get right is to get the cells with the value ‘D’ (or N also) to format in font in the colour I want and to change the fill to red if the column has the ‘S’ value in it.
How do I write a formula that will colour the font and fill for the two conditions?
I will also need to do the same for ‘N’
Thank you
I have a chart with the days of the week across the top, dates just below and then a shift pattern below that. What I currently have is two conditional comments that work, to display the column with an ‘S’ in it (ie. Weekends) to fill red and a cell with a value of ‘D’ to colour green.
What I have been trying to do but just can’t get right is to get the cells with the value ‘D’ (or N also) to format in font in the colour I want and to change the fill to red if the column has the ‘S’ value in it.
Code:
=B$5:BJ$5="S" applies to =$B$5:$BJ$11
Code:
Cell Value equal to ="D"How do I write a formula that will colour the font and fill for the two conditions?
I will also need to do the same for ‘N’
Thank you
