View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
strider
 
Posts: n/a
Default how do I highlight an entire row based on the value of its content

How do I highlight a row based on the value in one of it's columns.
Lets says I have a list of tasks that I have to complete. One of the
columns is the status of the task. When I select the Complete status in that
column I want the whole row to automatically be grayed out. Is this
possible? How can I do this?