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