Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
#3
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
bolding cells in conditional formatting | Excel Worksheet Functions |