Hi Roger,

Pop this into the Datavalidationcustom

=MOD(A1,6)=0

HTH

Simon

Roger wrote:
I'm trying to format a cell to only allow a numerical value that is a
multiple of 6. Is there a function or conditional formatting that can handle
this?

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com