How to format a cell to only allow multiples of a number
 

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?

How to format a cell to only allow multiples of a number
 

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

How to format a cell to only allow multiples of a number
 

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