LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Conditional formatting Problem

Hello, I am running office 2003.

I have a conditioinal format that says if cell is less than 0 to turn the
cell red. I have cells that are red and they have a value of 0. they are
NOT less than zero yet they are still turning red.

The adjacent cells have formulas. when I take out the formula and just type
in the number the conditional formatting works correctly.

What would cause this? It is not happening on all cells. it si sporadic...

Any insight would be greatly appreciated!!

Thanks again...

Myssie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting problem SueL Excel Discussion (Misc queries) 5 January 21st 09 01:42 PM
Problem with conditional formatting WLMPilot Excel Discussion (Misc queries) 1 April 20th 08 05:34 PM
conditional formatting problem T. Valko Excel Worksheet Functions 10 June 22nd 07 02:39 AM
conditional formatting problem bookman3 Excel Discussion (Misc queries) 3 October 27th 06 07:08 PM
Problem with conditional formatting DarrenMPY Excel Worksheet Functions 2 July 27th 06 02:25 AM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"