Dear All,

I have the time sheet, where one 2nd row is for date, 3rd row for day. 3rd
row is equal to 2nd row and I change the the 3rd row to "=text(a2,"DDD"),
then its return Sat or Sun. Here I applied the conditional formatting that If
a3 = Sat or Sun then then color change to red, otherwise Green.
Is it possible that if a3 color is red then a2 also change to red?

Hi

You have to apply contitinal formatting to cell A2, where the condition
should be a formula to look at cell A3 with the same contitions as you
applied in A3

Hopes it helps

Regards,
Per

"TFMR" <(E-Mail Removed)> skrev i meddelelsen
news:C4313583-18F0-441D-BB65-(E-Mail Removed)...
> Dear All,
>
> I have the time sheet, where one 2nd row is for date, 3rd row for day. 3rd
> row is equal to 2nd row and I change the the 3rd row to "=text(a2,"DDD"),
> then its return Sat or Sun. Here I applied the conditional formatting that
> If
> a3 = Sat or Sun then then color change to red, otherwise Green.
> Is it possible that if a3 color is red then a2 also change to red?
>

Apply the same CF to A2 as to A3?

--
__________________________________
HTH

Bob

"TFMR" <(E-Mail Removed)> wrote in message
news:C4313583-18F0-441D-BB65-(E-Mail Removed)...
> Dear All,
>
> I have the time sheet, where one 2nd row is for date, 3rd row for day. 3rd
> row is equal to 2nd row and I change the the 3rd row to "=text(a2,"DDD"),
> then its return Sat or Sun. Here I applied the conditional formatting that
> If
> a3 = Sat or Sun then then color change to red, otherwise Green.
> Is it possible that if a3 color is red then a2 also change to red?
>