Conditional Formatting

jimboayr · 07-28-2009, 07:50 PM

I have a work sheet (B) that is linked to another sheet (A). All the links in work sheet B are showing as zero. I haved used conditional formatting to make the cell text white until I type something into work sheet A and the the text in work sheet B will change accordinally.
My problem is that somtimes I need to put a zero in and have it showing as a zero. But as the conditional formatting is set to make it white, how can I get it to show as a black zero?

Richzep · 07-29-2009, 09:58 AM

Gosh. That's bit of a tall order. Not sure if you can tell it one thing one minute and change your mind for just some of it. I am a husband so I know this concept does exist. The only way I can think of is that on sheet A you enter the 0 with an apostrophe in front of it '0 This is hardly good spreadsheet management but it might be the answer to your problem.

jimboayr · 07-30-2009, 06:34 AM

Richzep,
Thanks for that information by the looks of it that seems to be the only way around it for the time being.
That is until someone can come up with a better idea that is good spreadsheet management.

07-28-2009, 07:50 PM	#1 (permalink)
jimboayr Registered User Join Date: Jul 2009 Posts: 5 OS: Win XP	Conditional Formatting I have a work sheet (B) that is linked to another sheet (A). All the links in work sheet B are showing as zero. I haved used conditional formatting to make the cell text white until I type something into work sheet A and the the text in work sheet B will change accordinally. My problem is that somtimes I need to put a zero in and have it showing as a zero. But as the conditional formatting is set to make it white, how can I get it to show as a black zero?

07-29-2009, 09:58 AM	#2 (permalink)
Richzep Registered User Join Date: Feb 2008 Posts: 48 OS: XP SP2	Re: Conditional Formatting Gosh. That's bit of a tall order. Not sure if you can tell it one thing one minute and change your mind for just some of it. I am a husband so I know this concept does exist. The only way I can think of is that on sheet A you enter the 0 with an apostrophe in front of it '0 This is hardly good spreadsheet management but it might be the answer to your problem.

07-30-2009, 06:34 AM	#3 (permalink)
jimboayr Registered User Join Date: Jul 2009 Posts: 5 OS: Win XP	Re: Conditional Formatting Richzep, Thanks for that information by the looks of it that seems to be the only way around it for the time being. That is until someone can come up with a better idea that is good spreadsheet management.