formula for conditional formatta divisible by 5

[chubbychub]

hi, i want to use a formula in the conditional formatting to be divisible by 5, how can i accomplish this? for example, i want to be in red , if its 5 or 10 or 15 or 20 or 25 and so on

so my formula is '=sum(B:B)' if this sums upto 5, or 10 or 15 or 20 ..if it sums up to any intervals of 5, then to place the conditional formatting

[Estevaoba]

Maybe this formula for the conditional formatting:
=MOD(cell with value,5)=0

Good luck!

[chubbychub]

it doesnt allow me to use that formula in excel 2019
says 'you may not use reference operators (such as unions, intersections and ranges)'

[Estevaoba]

Hit Conditional Formatting on the Home ribbon;
New rule
Use a formula to determine which cells must be formatted
In the "Format values in which this formula is true" box, paste that formula from post #2;
Select desired formatting
OK

[chubbychub]

that is exactly what i did , and this is what comes up when i click OK
'you may not use reference operators (such as unions, intersections, and ranges) or array constants for Conditional formatting criteria. '

[Phuocam]

Try this:

=($B2<>"")*(MOD(SUM($B$2:$B2),5)=0)

[Estevaoba]

I did it here and it works just fine.
Please check file attached.
If problem persists, please post a sample workbook here, as per instructions at yellow banner above.

[chubbychub]

Estevaoba yes it does work, you replaces the 'cell with values' with the cell with values, i just pasted the whole thing. Duh me! .. so silly of me. thank you all Estevaoba and Phuocam ! thread solved and reps added, thank youagain!

[Estevaoba]

You're welcome. Glad to help.
Thank you for the feedback, for marking the thread SOLVED and for the rep points added.