Conditional formatting

[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

 

[Peo Sjoblom]

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

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

--

Regards,

Peo Sjoblom

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!

 

[Frank Kabel]

Hi
try the following:
- select cell A1:A3
- goto 'Format - Conditional Format' and enter the formula
=(A$1>A$2)*(A$2>A$3)