Hi, I would like to make a cell in a specific color if another cell has a
value higher than a value specified by me.

I know how to do it if I want to change the coulor in the same cell (don't
know the english term for this) formatting with terms (or something like
that) But when it's another cell that has the value I'm lost.

Format -- Conditional Formating -- Put in the values you would like. After
you set the condition, you can then change the cell color, etc. by clicking
on the button "Format" just below and to the right of the condition you set.

"FreddieP" wrote:

Hi, I would like to make a cell in a specific color if another cell has a
value higher than a value specified by me.

I know how to do it if I want to change the coulor in the same cell (don't
know the english term for this) formatting with terms (or something like
that) But when it's another cell that has the value I'm lost.

But this is only when it's the same cell I want to change the color in.
My question is that for eample if I have a value higher than 0 in cell A1 I
want cell B1 to get a yellow background.

I cant find this in conditional formatting?

"REJesser" wrote:

Format -- Conditional Formating -- Put in the values you would like. After
you set the condition, you can then change the cell color, etc. by clicking
on the button "Format" just below and to the right of the condition you set.

"FreddieP" wrote:

Hi, I would like to make a cell in a specific color if another cell has a
value higher than a value specified by me.

I know how to do it if I want to change the coulor in the same cell (don't
know the english term for this) formatting with terms (or something like
that) But when it's another cell that has the value I'm lost.

If the other cell is say C2 and the value you specify is say 5 then

Select Format Conditonal Formatting and click on the arrowhead at "Cell
value is" and select "Formula is"

then enter the formula:

=$C$25

If you want to allpy it to seveal cells then you may have to remove the $
signs which are making the cell reference absolute.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"FreddieP" wrote in message
...
Hi, I would like to make a cell in a specific color if another cell has a
value higher than a value specified by me.

I know how to do it if I want to change the coulor in the same cell (don't
know the english term for this) formatting with terms (or something like
that) But when it's another cell that has the value I'm lost.

Use "Formula Is" instead of "Cell value is"

FreddieP wrote:
But this is only when it's the same cell I want to change the color in.
My question is that for eample if I have a value higher than 0 in cell A1 I
want cell B1 to get a yellow background.

I cant find this in conditional formatting?

"REJesser" wrote:


Format -- Conditional Formating -- Put in the values you would like. After
you set the condition, you can then change the cell color, etc. by clicking
on the button "Format" just below and to the right of the condition you set.

"FreddieP" wrote:


Hi, I would like to make a cell in a specific color if another cell has a
value higher than a value specified by me.

I know how to do it if I want to change the coulor in the same cell (don't
know the english term for this) formatting with terms (or something like
that) But when it's another cell that has the value I'm lost.

In Conditional Formatting, instead of using "Cell Value Is", use "Formula
Is".
--
David Biddulph

"FreddieP" wrote in message
...
Hi, I would like to make a cell in a specific color if another cell has a
value higher than a value specified by me.

I know how to do it if I want to change the coulor in the same cell (don't
know the english term for this) formatting with terms (or something like
that) But when it's another cell that has the value I'm lost.