Thread
:
Using formulae to change the colour of cells in Excel
View Single Post
#
2
Posted to microsoft.public.excel.misc
JE McGimpsey
external usenet poster
Posts: 4,624
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.
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey