Cells ending in '0'

Closed
generalgort - 30 Nov 2011 à 05:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 Nov 2011 à 13:37
Hello,

Is it possible to use conditional formatting to highlight the cells in a column of sequencial numbers ending in '0'? ie 10, 20, 30 etc to make it easier to see where you are

Regards
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
30 Nov 2011 à 13:37
Are they numbers or they are text.
If number you can use Mod function. If they are text you can use right function