How to Speed Up Windows 10: How to Fix - Conditional formatting blank ("") cell?

Conditional formatting blank ("") cell

I have Excel 2010 cells with an error handler in the formula as follows:
=IF(ISERROR(D22/C22),"",D22/C22)
These cells are conditionally formatted to fill red if the number is greater than 1. Problem is if the cell is blank ("") it is getting formatted red.
I tried adding another rule to say if the cell is blank, don't format it but that does not work. How do I fix this?

Solutions to the Problem Conditional formatting blank ("") cell

Download Error Fixer (Free)

Your formula can be better written in Excel 2010 with,

=IFERROR(D22/C22,"")

The IFERROR() function was introduced with Excel 2007.
Regarding your second question, the "" returned by your formula can be determined by LEN() or SUM().
The former can be used in an AND() like this,

=AND($A12>0, LEN($A1))

...
a zero length string will equate to FALSE as a boolean false is considered
0 when used mathematically TRUE is anything that is not FALSE.
The latter like this,

=SUM($A1)>0

IFERROR function

AND function

LEN function

SUM function

Note: It is recommended that you back up your files and folders before attempting this step:

Move the mouse cursor over to the upper right side of the screen.
A menu will pop up on the left. Click on the "Settings" feature on the menu.
On the Settings window, click on the "Change PC settings."
Now, left click on the "Update and recovery" feature.
For the next step, left click on the "Recovery" feature.
There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
Now, follow the instructions on the screen to finish the Refresh process.
After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
Check again to see if the error Conditional formatting blank ("") cell has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Recommended Method to Fix the Problem: Conditional formatting blank ("") cell:

How to Fix Conditional formatting blank ("") cell with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your computer. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.