View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sore Sore is offline
external usenet poster
 
Posts: 1
Default 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