View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Using formulae to change the colour of cells in Excel

One way:

You can Conditionally format many cells at once.

Select, say, B1:J10, with B1 the active cell.

Choose Format/Conditional formatting and enter the following format:

CF1: Formula is =A1<B1
Format1: <pattern/<red

XL will adjust the formula for the other columns/rows.

In article . com,
wrote:

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.