Cell Formatting

  • Thread starter Thread starter TFMR
  • Start date Start date
T

TFMR

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
 
Back
Top