Conditional format not carrying over from linked cell

S

SFC Traver

I have a cell...
Sheet1!D30
that is conditionally formatted to be red if the cell is blank, yellow if
the date is over 90 days, and green if less than 90 days. Works great.

I then linked it to another sheet....
=IF(Sheet1!D30="","",'Sheet1'!D30)
but the formatting didn't transfer and it now stays yellow. I'm guessing
because the cell is not blank anymore. The conditional format is formula
equals
=ISBLANK(D30)=TRUE

Any way to keep the format from the original cell into the new linked cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
Changing cell colors 1
Conditional Formatting in Excel 2003 2
Conditional formatting with two columns 0
Conditional Formatting to Another Cell 0
Color Conditional Formating 2
2007 conditional formatting not playing ball 5
Conditional Formatting 0

Top