Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell on value difference.
Hi
I currently have the text changing colour if the value is greater (green) and (red) if the same or lower compared to the value in the previous cell. But i would like to have the background cell change colour if the value is 10% +/- difference from the previous cell as well. This would be very useful if any one could help. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cell on value difference.
Try something like
=ABS((A2-A1)/A1) 0.10 "Neil" wrote: Hi I currently have the text changing colour if the value is greater (green) and (red) if the same or lower compared to the value in the previous cell. But i would like to have the background cell change colour if the value is 10% +/- difference from the previous cell as well. This would be very useful if any one could help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting cell | Excel Discussion (Misc queries) | |||
Highlighting cell | Excel Discussion (Misc queries) | |||
Cell Highlighting | Excel Discussion (Misc queries) | |||
Highlighting A Cell | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |