Cell coloring according to the other cell's value

[Sore]

Hello.

Recently an administrative problem popped up, and in order to solve it
somehow I want to do the following:

Choosing a particular cell,which value I want to change according to my
needs.
According to the value of that cell,I want the whole(or at least parts
of it) column(row) of that cell to change its cells color (kinda
highlight it...thats the whole idea of the procedure..)

I saw that property in action,but couldnt recreate it on the fresh
book.
I need it badly...

Please help if you know how to do it.

Thanks in advance.
Sore.

 

[Bernie Deitrick]

Sore,

Visit Chip Pearson's excellent website, specifically

http://www.cpearson.com/excel/RowLiner.htm

HTH,
Bernie
MS Excel MVP

 

[David Biddulph]

Conditional Formatting.
Use "Formula Is", rather than "Cell Value Is"