G
Guest
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,
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,