conditional formatting Closed

Question

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?

venkat1926 · Answer

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

Conditional formatting

1 response

Similar discussions

Subscribe To Our Newsletter!