Conditional formatting

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
I am trying to use conditional formatting for a column with the following formula :=IF(I34>1,IMSUB(I34,C34),""). I want to highlight cells that contain all numbers greater than 10. When I put this in for conditional formatting, it automatically highlights the cells even without any numbers in the cell. How do I resolve this?

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
You have to chear the computer

suppose the formula is in A1
in S1 the conditional format is

formula is I34>1

choose the color pattern

DO NOT USE CONDTITIONAL FORMATTING
CELLS VALUE EQUAL TO 0(ZERO)

Strictly A1 is not blank it is having a formula
you can do an experiment
suppose due to formula A1 is blank
in another cell type
=A1=0 it will give false

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!