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)

You can do this with a conditional format, but the question is, what are the
conditions? I think I'd try something like this

=DATE(Year(A1),montH(A1),day(A1))=Date(2008,1,1)

My only problem with this is that the date for next year is hardcoded in the
cell.

"Shelby" wrote:

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)

Isn't
=DATE(Year(A1),montH(A1),day(A1))=Date(2008,1,1)
the same as
=A1=Date(2008,1,1)
or as
=YEAR(A1)=2008 ?
--
David Biddulph

"Barb Reinhardt" wrote in message
...
You can do this with a conditional format, but the question is, what are
the
conditions? I think I'd try something like this

=DATE(Year(A1),montH(A1),day(A1))=Date(2008,1,1)

My only problem with this is that the date for next year is hardcoded in
the
cell.

"Shelby" wrote:

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)