Some Positive cell values display in RED font

I want to display the values in a financial report (created in Excel 2010) so that the values less than 0 will display with parentheses in Red font. When I apply the following format I get inconsistent results:  #,##0);[Red](#,##0) .

Strangely, in certain Excel reports, some positive values are also displaying in Red. Again, only SOME of the values are displaying incorrectly.  Does anyone know what causes this? These are formal, regular financial reports that must be correct.

See attached slice of a report.

Thanks for your help.
RedFont-Sometimes-Wrong.xlsx
thutchinsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
The two examples you show are formatted as red text, and are not changed by the conditional formatting.

You can also see that the text color is slightly off from Text Formatting and Conditional Formatting colors:

Color Variations
ChloesDadCommented:
Following on from the first post by ThinkSpaceSolutions, the conditional format is only changing values that are <0. If you want to force >=0 values to black then you should add that as an extra condition in the rule that you have already set up.
thutchinsonAuthor Commented:
I was fooling around with conditional formatting to see if I could correct it.  I guess I chose the wrong red tone.

So, some of the values are actually text and don't easily convert to numbers when formatting is applied?  This file is an output from a cloud-based app.
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

ChloesDadCommented:
What are the values that you are concerned about?

Are they in your sample file already posted?
Steven HarrisPresidentCommented:
So, some of the values are actually text and don't easily convert to numbers when formatting is applied?

Conditional formatting is "logical" at this stage and numeric versus text is kind of irrelevant.  If it runs across clear text, it would then be <0 and have formatting applied according to your rules.  Does that make sense?

I guess the main point would be start fresh with the data (all black text) and re-apply the conditional formatting. If there is an error, provide an example with the error displayed.
thutchinsonAuthor Commented:
CloesDad,
The values that I'm "concerned about"  are clearly indicated in far right column and Col1 is highlighted in yellow.

ThinkSpaceSolutions,
I will try your suggestion and try taking all values to black first and then apply conditional formatting.
ChloesDadCommented:
And by adding the extra conditional format they change to black.

I was referring to the text rather than numbers that you suggested will be imported into the spreadsheet
Steven HarrisPresidentCommented:
See if this looks any better.

I used Ctrl+a to select entire worksheet and then formatted all text to black.

Conditional Formatting was not changed and all values greater than or equal to 0 (>=0) are black, while all values less than 0 (<0) are red.
RedFont-Sometimes-Wrong--1-.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
thutchinsonAuthor Commented:
That's the one!  Thanks  Thinkspace!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.