Conditional cell colors

[Lonely Ranger]

Dear Friends,

I want to assign Cell A1 and A2 with two different colors if value in A2 is smaller or greater than that of in A1. Is it possible to do? If YES, HOW?

Thx all in advance

Lonely

[sweep]

Hi,

Take a look at conditional formatting. It can be found in the Home section of the ribbon in the styles area.

[Lonely Ranger]

Thanks for the speedy response. But its to critical to understand.

Could you please elaborate the formula?

Thanks again

Lonely.

[zbor]

Try follow this:

Select one cell (or group of cells), choose Conditional formatting and follow steps like in picture

untitled.JPG

You can add one rule when it's bigger (with one color) and other rule when it's smaller (with other color).

[oldchippy]

Hi,

Something like this should work for you

[Lonely Ranger]

Dear Friends,

I am sorry that none of the above could solve my problem.

Let me clear the thing; suppose:

a1= 2
a2= 4
a3= 3
a4= 5

I want to assign two different colours if value of a cell is greater or smaller than the previous cell. However, colour will remain same if value of a cell is same as the previous one.

Is there anyone to solve the above?

Thx to all who already tried to help me in solving the problem.

Regards,

Lonely

[martindwilson]

you have to read the help file
but format a2 as
condition 1
greater than =a1
pick colour
condition 2
less than =a1
pick colour
then copy a2
select range
a3:a50 or whatever paste special formats
read zebors post and look at picture
but change from =$a$1
to =a1.

[JBeaucaire]

I think he's saying that he only wants two colors. He wants them to alternate colors, but only when the values in column A are different. When the adjacent values are the same, he wants them to stay the same.

Like this macro does:

Please Login or Register  to view this content.