Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Suppose I have three cells in a column. If the first cell is greater than the second and the second is greater than the third, I want all three cells to have a red background. For example, if A1 is greater than A2 and A2 is greater than A3, I want A1, A2 and A3 to display a red background. I got part of this working by using a conditional format in A1. However, this only makes A1 be red. How can I make A2 and A3 also be red if the condition in A1 is true

A related question: when I do the conditional formatting, is there a way to just add a red background and not change the rest of the formatting? When I got the conditional formatting going on one cell (well, partially going, as described above...) and copied the formatting to other cells, not only did it change the color correctly to red, but it changed the border widths to what they were on the original cell. I didn't want that to happen

Thanks
Greg
 
Select all 3 cells, do format>conditional formatting formula is

=AND($A$1>$A$2,$A$2>$A$3)

--

Regards,

Peo Sjoblom


Greg Reese said:
Suppose I have three cells in a column. If the first cell is greater than
Click to expand...
the second and the second is greater than the third, I want all three cells
to have a red background. For example, if A1 is greater than A2 and A2 is
greater than A3, I want A1, A2 and A3 to display a red background. I got
part of this working by using a conditional format in A1. However, this only
makes A1 be red. How can I make A2 and A3 also be red if the condition in A1
is true?
A related question: when I do the conditional formatting, is there a way
Click to expand...
to just add a red background and not change the rest of the formatting? When
I got the conditional formatting going on one cell (well, partially going,
as described above...) and copied the formatting to other cells, not only
did it change the color correctly to red, but it changed the border widths
to what they were on the original cell. I didn't want that to happen!
 
Hi
try the following:
- select cell A1:A3
- goto 'Format - Conditional Format' and enter the formula
=(A$1>A$2)*(A$2>A$3)
 
Back
Top