If "H" is in a cell(s) then use Conditional Formatting to shade

Select range for formatting then

Format==Conditional formatting==Cell value is : Equal to: ="H" , set
colour, OK

HTH

"Brad" wrote:

I have created a calendar that will shade out the weekends. I would like it
to have a different shade (for holiday's) - with possibly an "H" in the cell.

In the cells for the other workday's I will be leaving blank - or putting in
the number of hours - I'm taking off -- this last piece I have working as
well.

Any suggestions on how to automate the shading (with the possibility of an
"H" in the appropriate days cell(s))