I'm not sure I understand what you want formatted.

Can you post an example of some of your data and let us know which rows
should be formatted?

--
Biff
Microsoft Excel MVP


"Scott" wrote in message
...
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.