conditional formatting adjacent cells
 

I am looking for a formula that will look at the cell directly above it and
if it equals a certain value then it would add a conditional value. For
example:

Cell A1= Sat B1=Sun C1=Mon. ......G1=Fri
A2=1 B2=2 C2=3....... G2=5



I want this to shade Gray for Saturday and Sunday on a monthly basis. Where
A2 and B2 would be shaded Gray.


Thank You,

Use a formula of =OR(A1="Saturday",A1="Sunday"), and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jbsand1001" wrote in message
...
I am looking for a formula that will look at the cell directly above it
and
if it equals a certain value then it would add a conditional value. For
example:

Cell A1= Sat B1=Sun C1=Mon. ......G1=Fri
A2=1 B2=2 C2=3....... G2=5



I want this to shade Gray for Saturday and Sunday on a monthly basis.
Where
A2 and B2 would be shaded Gray.


Thank You,

Use formula is

=OR(A1="Sat",A1="Sun")

assuming that they are not ddd formatted dates, if so use

=WEEKDAY(A15)


Regards,


Peo Sjoblom

"jbsand1001" wrote:

I am looking for a formula that will look at the cell directly above it and
if it equals a certain value then it would add a conditional value. For
example:

Cell A1= Sat B1=Sun C1=Mon. ......G1=Fri
A2=1 B2=2 C2=3....... G2=5



I want this to shade Gray for Saturday and Sunday on a monthly basis. Where
A2 and B2 would be shaded Gray.


Thank You,