How do I format cells with conditions set on another cell?

  • Thread starter Thread starter Shelby
  • Start date Start date
S

Shelby

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.
 
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 said:
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 said:
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)
Click to expand...
Click to expand...
 
Back
Top