| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
How do I make a cell red if A1 minus B1 not equal C1
is this possible??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
