Changing background colour when changing data in a cell

[Paoul]

I want a cell to change its colour to green when another cell has yes in itl.
If it does not have yes in it i want it to be red. Ive tried using the iF
function but i dont know how it works and i keeep getting errors

Help is appreciated

Thank you

 

[Don Guillett]

format>conditional format>etc

 

[dlw]

use Format/Conditional Formatting

 

[Jack Gopher]

Hi Paoul,

What you're talking about is called in excel "conditional formatting" .

You can find here some tutorials for getting started with using it:

http://www.free-training-tutorial.com/conditional-formatting.html

 

[Paoul]

I can do it for same cells but i cant seem to find a way to do it so it
changes a different cell. The rules in the conditional formatting seems to be
stuck to particular cells

 

[Gord Dibben]

Look out for $ signs in the CF>Formula is:

Excel tries to help and places absolute references like $A$1 when you may
want $A1 or A1 for copying to other cells.


Gord Dibben MS Excel MVP

 

[Excel_Learner]

Suppose your values are in Column A. Select column B go to conditional
formattin..choose "formula is" and type =$a2="YES" and click on format and
change the color of cell to green. Add condition 2...chosse "Formula is" and
type =$a2<>"YES" go the format and change the cell color into red.. it will
work.

 

[Excel_Learner]

Suppose your value is in column A. Then select column B and go to conditional
formattting. Condition 1: select "Formula Is" and type =$a2="YES". Click on
Format button and change the color into green. Condition 2: select "Formula
Is" and type = $a2<>"YES". Click on Format button and change the color into
Red. This works