Highlighting Cells uisng conditional Formatting where cell value > 0

[bearcub]

I have a draw spreadsheet where I reps get 3 draws. I would like to highlight cells that >0 and left the cells without anything with no fill.

The present formula I am using is SUM($D5:$Y13)>4999

I need something in the formula to exclude blank cells,

Is this possible?

Thank you in advance for your help.

Michael

 

[Joe4]

I am a bit confused by your question. I am not sure what a "draw" spreadsheet is.
Also, if you just want to check to see if cells have numbers greater than 0, what does the SUM calculation have to do with it?
There seems to be some key details/explanations missing that we need so we can understand what you are working with and exactly what you are trying to do.

 

[bearcub]

Sorry Joe, I'm doing commissions and some reps get advances (draws against commission). I'm going to have some cells that will have something (a draw and the draw 1 of 3, for example) but most of the cells in the row will be empty. I would like to highlight the cells that contain values. Maybe the formula I'm using is incorrect, may Not(Isblank(range)) would work?

 

[Joe4]

Let's, for example, say that you wanted to highlight cell D5 if it is not blank.
One way is to use the Conditional Formatting formula of:

=D5<>""

and then choose your formatting option.

 

[bearcub]

thank you, that works great! I was overthinking the situation, like usual

 

[Joe4]

You are welcome.

 

[bearcub]

You provide me with an idea to how I could highlight the number of draws being paid though I haven't done it yet.

I have cell next the the amount being paid with either a 1,2 or 3. I would need to create 3 new rules for each number using a different fill. I would use your formula except that i would use

D5=1
D5=2
D5=3

Simple but effective.

Thank you again