Conditional formatting

[amit.nikhil]

hi, I m unable to apply conditional formatting with numbers ( font and fill of same color).

like:-
if press 1 , cell and font should be of same color and if 2 with different color and so on

as of now either formula is applying on cell or font but not on both

pls help

[Fotis1991]

Hi

You need different CF for eatch condition.

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.