Problem using Conditional Formatting in Excel 2000

[MisterBob]

Trying to use Conditional Formatting in Excel 2000 to have the shading change and the contents of another cell copied into the cell in question.

Example cell in question is F2
conditional format formula is =IF(AND(F$1>=$C2,F$1<=$D2),$E2, &quot;&quot

F1 = 1/1/2001
C2 = 1/1/2001
D2 = 10/15/2001
E2 = 60

The above &quot;AND&quot; returns TRUE and the cell shading changes to light blue, my choice, but the contents of cell E2 does not show up in cell F2. What Am I forgetting or doing wrong?

 

[euskadi]

Conditional formatting changes the formatting for a cell or range only. If you want &quot;60&quot; to show up in cell F2 you'll need to change the equation for F2 as well.

 

[MisterBob]

The equation is in cell F2!!!

Thanks

 

[euskadi]

Is the font color the same as the cell color making the value invisible?

 

[MisterBob]

Many thanks, found the cure for the problem. I set the font color to be the same as the cell color for the cell normal formatting. Had cell F2 reference cell E2. When the formatting formula returns true it set the font color to dark blue and the cell shading to light blue. So if I can do it for one it will work for all of them.

Thanks for your help.