View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Conditional Format Help Needed

That doesn't quite work. With that formula, it only works on alternating
rows (much like the alternating row fills work). For instance, if the even
rows are white, and the odd rows are gray-filled, and an even row has the
"Ready to Publish" tag, the text in the even row will not be grayed out.
However, odd rows, given the same circumstance, will be grayed out. I want
that option for all rows.