Using formulae to change the colour of cells in Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

.

Relevant Pages

  • Re: Changing text color usinf a formula (NOT Conditional Formatting)
    ... look in help for conditional formatting ... click the format button and select font colour and click OK twice ... Excel 95 - Excel 2007 ...
    (microsoft.public.excel.misc)
  • importing from Outlook to Access or vice versa
    ... addresses in an Access database. ... to type it twice? ... But it is very time consuming to type all that ... Michelle ...
    (microsoft.public.access.externaldata)
  • Re: conditional format business day
    ... will work albeit ugly ... Peo Sjoblom ... select a format to apply and click OK twice ... How can I do this with conditional formatting? ...
    (microsoft.public.excel.misc)
  • Re: redirect to a file and to the screen?
    ... For dir, you could just do it twice, but for more time consuming ... applications, doing it twice is not such a great option. ... Stream splitter from http://64.38.67.11:8080/freeware/tee.zip ...
    (microsoft.public.windowsxp.general)
  • Re: Date Formula Problem - Leave date blank if Null
    ... You might be better off using conditional formatting to "hide" the zero. ... could write the blank into the formula but then it'll be twice as long. ... Set the Font color to be the same as the fill color ... I just want the cell left blank. ...
    (microsoft.public.excel.worksheet.functions)