conditional formatting
 

How do I make a cell red if A1 minus B1 not equal C1

is this possible???

conditional formatting
 

Highlight the cell or cells you want to turn red. On the menu click Format,
Conditional Formating. Change the first drop down box in Condition 1 to read
"Formula Is" then type =$A$1-$B$1=$C$1. (Hint: if you have highlighted a
range of cells and want the condition to check the cells that are in the same
relation to each cell rather than specifically checking A1, B1, and C1 each
time you'll want to get rid of the $'s.) Click Format and format
accordingly. That should do it.

Erin

"jacob" wrote:

How do I make a cell red if A1 minus B1 not equal C1

is this possible???

conditional formatting
 

Make that =$A$1-$B$1<$C$1


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 13:29:03 -0800, "Erin Searfoss"
wrote:

Highlight the cell or cells you want to turn red. On the menu click Format,
Conditional Formating. Change the first drop down box in Condition 1 to read
"Formula Is" then type =$A$1-$B$1=$C$1. (Hint: if you have highlighted a
range of cells and want the condition to check the cells that are in the same
relation to each cell rather than specifically checking A1, B1, and C1 each
time you'll want to get rid of the $'s.) Click Format and format
accordingly. That should do it.

Erin

"jacob" wrote:

How do I make a cell red if A1 minus B1 not equal C1

is this possible???

conditional formatting
 

Thanks. I didn't see that "not".

"Gord Dibben" wrote:

Make that =$A$1-$B$1<$C$1


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 13:29:03 -0800, "Erin Searfoss"
wrote:

Highlight the cell or cells you want to turn red. On the menu click Format,
Conditional Formating. Change the first drop down box in Condition 1 to read
"Formula Is" then type =$A$1-$B$1=$C$1. (Hint: if you have highlighted a
range of cells and want the condition to check the cells that are in the same
relation to each cell rather than specifically checking A1, B1, and C1 each
time you'll want to get rid of the $'s.) Click Format and format
accordingly. That should do it.

Erin

"jacob" wrote:

How do I make a cell red if A1 minus B1 not equal C1

is this possible???