Thread: Cell Formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Cell Formatting

Apply the same CF to A2 as to A3?

--
__________________________________
HTH

Bob

"TFMR" wrote in message
...
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?