Previous Topic Next Topic

Conditional formatting

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 -
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

Answer 1 / 1
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 803
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
Ask a question