Cond Formatting driving me MAD!

[ad1234]

I want values >= 1 Green, = 0 Amber, <= -1 Red.... and blanks to remain unformatted. It is the blanks bit that is causing me difficulty/ I have a formula in the cells, removing this by doing copy/paste special/paste values doesn't work.

I've tried all I can think off, looked online etc. but cannot find how to do this simple (in older versions) task. I know this must be very simple!! Help please!?

Thanks

ad1234

 

[ad1234]

A Null String ("") is a 0 length text string, text > number hence Null String > 0

You can use a formula based test:

=SUM(A1)>0
format Green

Now that is worth knowing.... I'm going to try that!

 

[ad1234]

Yes I tried that too....

 

[ad1234]

Hooray to that - I couldn't agree more!

 

[ad1234]

Conditional Formatting prior to 2007 was solid..

Since 2007 and 2010 (the near same platform) conditional Formatting has (in my opinion) gotten "all screwed up". Traditionally, (since Excel 97) when engagng C/F
on a worksheet - I'm use to selecting oly ONE cell to setup the formatting on -- and 95% of the time (if not 99%) I've always selected the "FormulaIs" option, enter a Formula and "BAM", it works!! -- From there I'd use the Format Painter to apply the One to the Many other cells... TRY DOING THIS IN 2007 or 2010 - It seems to work "on the surface" - But when you go back into MANAGE RULES ---- Holy Crap!!! -- I've seen 10, 20 or more rows of Items -- C/F in 2007 and 2010 is SHAKEY, to me..

I just couldn't agree more!

 

[ad1234]

I did try that but I need to go back and look at the various suggestions on here... and include that too.

Many thanks to you all for your help....

ad1234