adding color to formula

I have two columns in a spreadsheet that have the following formula =IF(j8="",0,G8), I need to add something to this column that will flag if collections drop for three months in a row, whether it be changes color to make sales staff aware of the drop and the other question is how to change the color of a complete row if the word yes appears in column b, which signifies for three months that this is a new client. Any help with these formula problems will be greatly appreciated.

Hi
not possible with a formula but with conditional format. e.g. for your
second parts of your question:
- select your rows (e.g. you start in row 8)
- goto 'Format - conditional format' and enter the following formula
=$B8="yes"
- choose a format

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
I have two columns in a spreadsheet that have the following formula
=IF(j8="",0,G8), I need to add something to this column that will
flag if collections drop for three months in a row, whether it be
changes color to make sales staff aware of the drop and the other
question is how to change the color of a complete row if the word yes
appears in column b, which signifies for three months that this is a
new client. Any help with these formula problems will be greatly
appreciated.

you can accomplish this with the "conditional formatting" feature


---
Message posted from http://www.ExcelForum.com/