See one solution in worksheet.functions.

Please don't post the same message to multiple groups - it just
fragments any answers and potentially wastes the time of those
replying.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm



In article ,
"Scott V." wrote:

Hello,
I would like to set a parameter so that when a certain
cell reaches a given value the entire row will turn a
specific color or be stricken through. Example is below...

Completed...... Strikethrough
In Progress...... Green
Not Started...... Blue
Started........ Yellow

I have tried to use the conditional formatting and that
works well but is limited by only the current cell, vs the
entire row and this causes a reading issue. Is there an
answer for this?

Any and all help will be greatly appreciated.

Thanks,

Scott