Conditional Formatting Help

[ItalianPlatinum]

Hello I have what I thought was an easy modification, but having issues finding an easy way to solution. I have 3 columns one column is pre, one is post, and the 3rd is differences. I have existing conditional formatting in column C to highlight red if the data isn't zero and green if the data is zero. The new condition i was looking to add is if any data below the header equals zero to highlight the header green and if any don't equal zero to highlight the header red.

Pre	Post	Differences
1	2	-1
1	1	0
2	2	0
3	4	-1

So in this scenario "Differences" would be shaded red as well as the first and last record. If those records were zero then all 5 in column C would be shaded green including the header "Differences." Any help is much appreciated as always.

 

[awoohaw]

I noticed if I don't do stop if true it'll flag green shade and white font. BUT if i do stop if true for the GREEN it does the correct conditional shading (green shade and automatic font). is that weird to you?

you probably have more than one conditional formula set for that cell. (click the drop down to show all conditional formats for all cells in the worksheet).
(ie.. change current selection to worksheet)
Also, please screen shot the header row as well. I can't tell what rows you're on.

EDIT: actually I see "Differences" is not even colored. So I think you have multiple rules going on.

 

[ItalianPlatinum]

I got it to work using @Joe4 formulas, see below. I am now just left with the blank cells showing green, anyway around that or do i need to create another conditional format looking for blanks?

C1 , Green Shade =COUNT($C$2:$C$5000)-COUNTIF($C$2:$C$5000,"0")=0
C1 , Red Share =COUNT(C2:C5000)-COUNTIF(C2:C5000,"0")>0

 

[awoohaw]

Okay, so you have formulas that return "" if there is nothing to calculate in the two prior columns?
The format would be, (this is me typing not working in excel)

=C2 = ""

and make that no fill color.