Why don't you just use the original formula, and C F on a value of 0 with a
red font and red background?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Veretax" wrote in message
...
That works swell in fact I made an adaptation on it to take into account
if
there is no date logged

=IF(MAX(IF(PosterRange="Margo",DateRange))=0,
"Never",MAX(IF(PosterRange="Margo",DateRange)) )

it has to be entered as an array forumla as before I believe, but with a
little conditional formatting I have those who never post with Never in
red
Thanks for the help, Couldn't figure out why it wasn't working properly.