| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding / Cond. Format
How (in conditional formatting) can I ask excel to allow a difference of +,-
..01? For example, A1=12.21 and B1=12.22. I want B1 to turn red if it is not equal to A1, allow a .01 difference. In this case B1 will not turn red. If A1=12.21 and (B1=12.23 or B1=12.19), then the cell (B1) will turn red. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding / Cond. Format
It's 2 conditional formats in B1.
cell value - is greater than =$A$1+0.01 and the second one cell value - is less than =$A$1-0.01 and pick a nice colour. Mike "Teddy-B" wrote: How (in conditional formatting) can I ask excel to allow a difference of +,- .01? For example, A1=12.21 and B1=12.22. I want B1 to turn red if it is not equal to A1, allow a .01 difference. In this case B1 will not turn red. If A1=12.21 and (B1=12.23 or B1=12.19), then the cell (B1) will turn red. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding / Cond. Format
=ABS(ROUND(B1-A1,2))0.01
"Teddy-B" wrote: How (in conditional formatting) can I ask excel to allow a difference of +,- .01? For example, A1=12.21 and B1=12.22. I want B1 to turn red if it is not equal to A1, allow a .01 difference. In this case B1 will not turn red. If A1=12.21 and (B1=12.23 or B1=12.19), then the cell (B1) will turn red. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding / Cond. Format
Great formula - Thanks for your help!
"Teethless mama" wrote: =ABS(ROUND(B1-A1,2))0.01 "Teddy-B" wrote: How (in conditional formatting) can I ask excel to allow a difference of +,- .01? For example, A1=12.21 and B1=12.22. I want B1 to turn red if it is not equal to A1, allow a .01 difference. In this case B1 will not turn red. If A1=12.21 and (B1=12.23 or B1=12.19), then the cell (B1) will turn red. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cond format with date | Excel Worksheet Functions | |||
| Whole Row Cond. Format | Excel Discussion (Misc queries) | |||
| cond format | Excel Worksheet Functions | |||
| HLookup or Cond. Format? | Excel Worksheet Functions | |||
| using a UDF in place of a cond. format, b/c I need 4, not three | Excel Discussion (Misc queries) | |||
Linear Mode
