Hi Roger,
That will only allow you to enter a number divsible by 6 into a cell.
If you put the forumla into the conditional format it will just highlight the
required numbers.
Thanks,
SImon
smw226 wrote:
Hi Roger,
Pop this into the Datavalidationcustom
=MOD(A1,6)=0
HTH
Simon
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