Previous Topic Next Topic

Conditional formatting

Closed
kellebelle34 - Jan 14, 2010 at 01:07 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 14, 2010 at 09:02 PM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 14, 2010 at 09:02 PM
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses