View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott V. Scott V. is offline
external usenet poster
 
Posts: 1
Default Color Rows Automatically

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