Hi All,

Please help me about conditional formatting, suppose I will type an exact word or value "TEST" in cell A2. Is there a way after typing the word "TEST" in cell A2 the cells from A1 to A5 will change to my desired fill color?

I know there's a way out here please help.

I am using MS OFFICE 2007

Thank you in advance.