View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shelby Shelby is offline
external usenet poster
 
Posts: 11
Default How do I format cells with conditions set on another cell?

I have a formula in a column (=SUM('[Leavers 2015 Progress
tracker.xls]READING'!$V$33)) which I do not want to use until next year. I
have coloured the font white and would like to change it to black when I
change the date in A1. Of course I can conditionally format B1:B10 from
B1:B10, but I can't do this without taking out my original formula!
I would be grateful for any help! :o)