I would like to apply conditional formatting to any cell within a range containing a value that is a multiple of itself.

IE: Apply bold font to any cell of column A that is a multiple of 4 (4,8,12,16,20,24, ...).

Can anyone help with this?


After continuing to play around with functions, I was able to find a solution! Here is the solution for those trying to attempt something similar:

=IF((AND((MOD(A:A,4) = 0),(NOT(ISBLANK(A:A))))), true, false)

  • Thanks for the edit @marikamitsos – JxN Aug 11 at 21:54
  • Welcome to Webapps. I deleted your Data Validation mention and tag because the way you state your question does not support their presence. (No need -as per site rules- to thank on the question. A polite and gentle behavior would suffice. You can always -as you did- use the comments area) Please read How to Ask and About asking. – marikamitsos Aug 11 at 22:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.