Hi,

Am Fri, 27 Sep 2013 16:47:40 +0100 schrieb sumesh56:

if the numbers start from 7 ie,701 to 799 the cells which contain should
have light green color.

in your table the numbers starting with 7 have red backcolor.

select D11:N15 = Conditional Formatting = use formula ...=
Formula: =--LEFT(D11,1)=7 and choose red background color.
Repeat it for your other values.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2