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.
