Formula

Closed
Max - May 12, 2009 at 02:00 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 13, 2009 at 02:06 AM
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 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 13, 2009 at 02:06 AM
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