Text to dictate colour of the cell and/or row
 

Hello all,

I hope someone can help.

I am trying to enter a formula to tell my spread sheet that if a value (any)
is entered into a particular cell, I would like that cell (pref the entire
row) to turn a particular colour.

I have seen this before on other spreadsheets, and cannot figure out how to
do this.

Assistance is much appreciated.

Thanks

Aaron

Text to dictate colour of the cell and/or row
 

Conditional formatting:

http://www.contextures.com/xlCondFormat01.html


--
Gary''s Student - gsnu2007


"Aaron Hodson (Coversure)" wrote:

Hello all,

I hope someone can help.

I am trying to enter a formula to tell my spread sheet that if a value (any)
is entered into a particular cell, I would like that cell (pref the entire
row) to turn a particular colour.

I have seen this before on other spreadsheets, and cannot figure out how to
do this.

Assistance is much appreciated.

Thanks

Aaron

Text to dictate colour of the cell and/or row
 

Fantastic!!!

Thank you for the prompt response

"Gary''s Student" wrote in message
...
Conditional formatting:

http://www.contextures.com/xlCondFormat01.html


--
Gary''s Student - gsnu2007


"Aaron Hodson (Coversure)" wrote:

Hello all,

I hope someone can help.

I am trying to enter a formula to tell my spread sheet that if a value
(any)
is entered into a particular cell, I would like that cell (pref the
entire
row) to turn a particular colour.

I have seen this before on other spreadsheets, and cannot figure out how
to
do this.

Assistance is much appreciated.

Thanks

Aaron