LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - conditional formating on graphs. Change colour on a value Peter Shore Charts and Charting in Excel 5 June 9th 06 06:10 AM
Can a formula change a cells colour after a given length of time? Clive Humphries Excel Worksheet Functions 1 February 20th 06 10:23 PM
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? Daniel Excel Worksheet Functions 6 July 11th 05 11:24 PM
How do I get traffic lights in excel that change colour Shorty Excel Worksheet Functions 2 December 23rd 04 01:24 AM
How to get excel cells to change colors depending on value KV Excel Worksheet Functions 2 November 25th 04 09:50 AM


All times are GMT +1. The time now is 04:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"