... short of each one individually manually.

E.g. I have a column headed Day and I want each cell in it that contains Monday to be shaded blue.

First thought was Find and Replace > Format, but it lacks the Borders and Shading of Menubar > Format:



Second thought was use Menubar > Format > Borders and Shading after somehow auto-selecting the matching cells, but I find no such option.

Any ideas?

Thanks.