Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of numbers, which is updated twice a week, and I want to
make it easy to track increases and decreases in these numbers. I have read several of the posts on this forum, and many of them speak of conditional formatting. I have tried using this, but it only allows you to format one cell at a time, and as I have something like 85 numbers to check twice a week, this could be very time consuming. Does anyone know of a formula I can fill across that would be something like: IF(A1<B1, B1's background goes red) which I could then fill right to make: IF(B1<C1, C1's background goes red) and that could be filled down like so: IF(A2<B2, B2's background goes red) I would appreciate any help, thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - conditional formating on graphs. Change colour on a value | Charts and Charting in Excel | |||
Can a formula change a cells colour after a given length of time? | Excel Worksheet Functions | |||
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions | |||
How do I get traffic lights in excel that change colour | Excel Worksheet Functions | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions |