Thread: Can I conditionally format a line based on a cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default Can I conditionally format a line based on a cell value
I do not believe that can be done. I would suggest using a Pivot Table so you
can parse out the data you need, then you can click in the date field, go to
Data - sort, and click descending...

"eoinp" wrote:

I want a 2003 Excel autoshape to have a dashed line if a particular cell
value is zero or solid if the value is one. Can Excel do this?
Reply With QuoteReply With Quote