Using formulae to change the colour of cells in Excel
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.
|