**Question description:**

*This user has given permission to use the problem statement for this blog.*

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

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
20/05/2018 - 11:24

HI

Excelchat Expert
20/05/2018 - 11:24

Welcome to Got it Pro

User
20/05/2018 - 11:25

hello

Excelchat Expert
20/05/2018 - 11:25

Can you share the sheet so that i can help better

User
20/05/2018 - 11:26

Unfortunately not, it is proprietary

Excelchat Expert
20/05/2018 - 11:26

ohk

User
20/05/2018 - 11:26

I could pretty easily create if you want

Excelchat Expert
20/05/2018 - 11:27

you can chnage the formatting and show them in commas

Excelchat Expert
20/05/2018 - 11:27

Like you show for numbers

Excelchat Expert
20/05/2018 - 11:27

so the cells which are blank will not be shown as 0

Excelchat Expert
20/05/2018 - 11:31

Do you get it?

User
20/05/2018 - 11:31

no

User
20/05/2018 - 11:31

if I have the following in a cell

Excelchat Expert
20/05/2018 - 11:31

I mean when you are taking data in sheet 2 from sheet 1 all balnk rows apprear as 0

User
20/05/2018 - 11:32

=Flight!B715

User
20/05/2018 - 11:32

dates show up as 1/0/00

Excelchat Expert
20/05/2018 - 11:33

=IF(Flight!B715="","",Flight!B715)

Excelchat Expert
20/05/2018 - 11:34

Use formula like this

Excelchat Expert
20/05/2018 - 11:34

So the blank values in flight tab will not become 0 on other tab

User
20/05/2018 - 11:35

testing

Excelchat Expert
20/05/2018 - 11:35

ok

User
20/05/2018 - 11:37

You are awesome! THank you

Excelchat Expert
20/05/2018 - 11:37

Welcome

Excelchat Expert
20/05/2018 - 11:37

Please do give good rating and reviews

Excelchat Expert
20/05/2018 - 11:37

It really helps

User
20/05/2018 - 11:37

Count on it

Excelchat Expert
20/05/2018 - 11:38

Thanks

Excelchat Expert
20/05/2018 - 11:38

Have a great day

User
20/05/2018 - 11:38

Where is the best place to leave feedback?

Excelchat Expert
20/05/2018 - 11:38

:)

Excelchat Expert
20/05/2018 - 11:38

When you end the session

Excelchat Expert
20/05/2018 - 11:38

you will get a popup to rate

User
20/05/2018 - 11:38

Thanks again

Excelchat Expert
20/05/2018 - 11:38

Welcome

Excelchat Expert
20/05/2018 - 11:39

You can end the session to provide your ratings

Excelchat Expert
20/05/2018 - 11:41

Are you there?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*