Conditional formatting

Question

Conditional formatting

[Closed]

Report

kellebelle34 - Jan 14, 2010 at 01:07 PM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- 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?

Conditional formatting
Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
Conditional formatting if another cell contains any text ✓ - Forum - Excel
Excel conditional formatting 5 color scale ✓ - Forum - Excel
Copy conditional formatting from one row to another ✓ - Forum - Excel
Excel conditional formatting if cell contains any date - How-To - Excel

1 reply

Ask a question

venkat1926 · Answer 1 · 2010-01-14T21:02:27-0500

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

800
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

Conditional formatting

1 reply

Your reply

Subscribe To Our Newsletter!