Cell coloring according to the other cell's value
 

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.




--
Sore

Cell coloring according to the other cell's value
 

Sore,

Visit Chip Pearson's excellent website, specifically

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

HTH,
Bernie
MS Excel MVP


"Sore" wrote in message
...

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.




--
Sore

Cell coloring according to the other cell's value
 

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

"Sore" wrote in message
...

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.




--
Sore