Conditional format entire column

PAB1020

New Member
Joined
Dec 21, 2018
Messages
14
Office Version
  1. 365
Platform
  1. Windows
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.
 
That should eliminate the div0 error you asked for, assuming that H6 is 0 rather than blank.
 
Upvote 0

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,215,025
Messages
6,122,732
Members
449,093
Latest member
Mnur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top