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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
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)