Conditional formatting

[Debbie Uniforms]

Hello,

I would like to format cells based on the value in another cell.

Eg, column A has names of staff. column B gives the score from an assessment.

I would like the name (column A) to change to red if the score in column B is 1. I'd like the name to change to orange if the score in column B is 2, etc etc.

I just know it can be done AND, I just know that one of you clever people can help me!

many thanks
Debbie Uniforms.

 

[AlanY]

or you can just follow Sandy's #5

 

[sandy666]

see this:

 

[sandy666]

Typical, I can't select the link at work as blocked! I'll have to look at home.

I didn't say select link but select column

 

[AlanY]

see this:

Sandy,

how do you create that animation? love to learn how to do it.

 

[sandy666]

almost coffee and almost sugar?


you need to buy software, create movie then covert movie to animated gif, that's all

 

[AlanY]

almost coffee and almost sugar?


you need to buy software, create movie then covert movie to animated gif, that's all

ok, guess i stick to excel and make my only coffee then

 

[sandy666]

ok, guess i stick to excel and make my only coffee then

it's $19.95 only