Formatting

[FreddieP]

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.

 

[REJesser]

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

 

[FreddieP]

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?

 

[Sandy Mann]

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$2>5

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bob I]

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

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?

:

 

[David Biddulph]

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