I am having a challenge with conditional formatting. My workbook has 2 sheets (SheetA, SheetB). When data is entered into some cells in SheetA, it automatically fills to the appropriate cell in Sheet B (=SheetA!cell #). This is working fine. The challenge I am having is the data in SheetA is formatted (date, number, etc.). When cells in SheetA are blank because data has not been input yet, there are 0's or incorrect dates in SheetB. What I want is to conditionally format the cells in SheetB to be blank unless data has been input into the reference cell in SheetA. Thank you for the help.
Solved by A. U. in 20 mins