ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional format not carrying over from linked cell (https://www.excelbanter.com/excel-discussion-misc-queries/177843-conditional-format-not-carrying-over-linked-cell.html)

SFC Traver

Conditional format not carrying over from linked cell
 
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?



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com