Conditional formate

[Suleman]

Dear Sir,

I want that As A1 is equale to Rejected Then the Next 5 Coloumn
B1,C1,D1.....change teh colour font and background also .

 

[JoAnn Paules]

Try posting your question over in one of the Excel newgroups. They are very
helpful over there with Excel issues.

 

[Suleman]

i don,t get you meaning please can you help me where newsgroup

Try posting your question over in one of the Excel newgroups. They are very
helpful over there with Excel issues.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Dear Sir,

I want that As A1 is equale to Rejected Then the Next 5 Coloumn
B1,C1,D1.....change teh colour font and background also .

 

[Bob I]

Yes use "Formula is" A1="Rejected" in Conditional formatting for B1 C1
and the rest.