Format cells that begin with an even number

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


Format cells that begin with an even number



I have a column of tags that begin with a number; eg. "1-text", "21-text". How can I identify tags that begin with an even number so that I can format the cells?





"begin with an even number" - do you mean an even digit (eg "21-text") or even number (eg "12-text") ?
– Tim Williams
1 min ago






1 Answer
1



You can use MOD() and ROW():


MOD()


ROW()


=IF(MOD(ROW(), 2) = 0, "Even", "Odd")






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Makefile test if variable is not empty

Will Oldham

Visual Studio Code: How to configure includePath for better IntelliSense results