Formula

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I require a excel formula to shade cells if the following criteria is met If A1 = X shade cells A2 to A10 grey

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Select Cells A2 to A10 but firstly select Cell A2 then A10 .... Now Go in Format > Conditional Formatting > Select condition 1 Formula is and write =$A$1="X" in right box now select format > Pattern and select gray shade ......



3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month