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

[Guest]

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?

 

[smw226 via OfficeKB.com]

Hi Roger,

Pop this into the Data>validation>custom

=MOD(A1,6)=0

HTH

Simon

 

[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