Feb 07 2019 03:24 AM - edited Feb 07 2019 04:11 AM
Hello, so I have a spreadsheet that logs a group of peoples weight loss/gain. I want to set up conditional formatting for a cell that shows the difference in weight each week. If its a gain I want it to turn red and if its a loss green. I'm struggling to work out how to do it, please could anyone help? Thank you
Feb 08 2019 03:28 AM
Jessica,
Have attached a sample of conditional formatting for you to play with
Rich
Feb 08 2019 06:14 AM
Hey. Please look in the attached document. Sorry, but my version is in Danish. Hope it can help you.
Best regards
Michael Simony