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

R

Roger

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?
 
S

smw226 via OfficeKB.com

Hi Roger,

Pop this into the Data>validation>custom

=MOD(A1,6)=0

HTH

Simon
 
S

smw226 via OfficeKB.com

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
 
Top