Conditional format entire column

[PAB1020]

My first post for help here.
I'm not a novice nor am I an expert.
I don't have a problem returning error message (with #DIV/0!) but I want it formatted with red font (not that the format matters).
I can get it to work - one cell at a time, but for 35 rows - gotta be a better way.
Formula is true: =ISERROR($I$31) Applies to =($1$31)
I want this top apply to all of Column I - I4:I36
Tried =ISERROR($I$4:$I36) - Applies to $I$4:$I36 - doesn't work, font stays black.

 

[Fluff]

Hi & welcome to MrExcel.
Select I4:I36 & use this formula in conditional formatting.

=ISERROR($I4)

 

[6StringJazzer]

=ISERROR(I4)
Do not use $!
Edit: The way that Fluff used $ is OK, for the column. Do not use it for the row.

Applies to
$I$4:$I36

 

[PAB1020]

And, if you can help me return something other than the error, that would be great.
Need percentages but sometimes dividing #>0/0.

 

[Fluff]

You can use

=IFERROR(your formula,"")

 

[PAB1020]

Hi & welcome to MrExcel.
Select I4:I36 & use this formula in conditional formatting.

=ISERROR($I4)

thanks - didn't try that - it works

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[PAB1020]

You can use

=IFERROR(your formula,"")

Fluff, thanks for the help.
Here's my DIV/0 issue...
This just happens to be row 6.
Calculating %'s above/below list price (G6) on what product sold for (H6).
Returning blank cell if no account name is entered in (A6) instead of column(s) full of 0.00%'s=IF(A6="","",IF(H6-G6=0,0,(H6-G6)/H6))
Negative numbers formatted in red font: 0.00%;[Red]-0.00%

 

[Fluff]

How about

=IF(OR(A6="",H6=0),"",IF(H6-G6=0,0,(H6-G6)/H6))

 

[PAB1020]

How about

=IF(OR(A6="",H6=0),"",IF(H6-G6=0,0,(H6-G6)/H6))[/CODE
[/QUOTE]

Sorry, Fluff, I really don't follow this at all