Conditional Formating two conditions

**tims31** · 07-04-2014, 07:54 AM

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.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

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

**Fotis1991** · 07-04-2014, 08:02 AM

Highlight your range and In Conditional Formating rules, use these.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.