Hi Duncan,

Am Tue, 9 Dec 2014 03:48:36 -0800 (PST) schrieb Duncan Edment:

Highlight the area C11:AK29;
Create a new rule, using a formula to determine which cells to format;
Format values where the following formula is true: =$C$11:$AK$29="L";
Format: Green background
Applies to: =$C$11:$AK$29;

the formula has to refer to the active cell of the selection
Try it with:
=C11="L"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional