I want to use column D as my automated testing column. I want it to show Green if the test works and Red (with white ink) if it fails. That way the spreadsheet should shout out at me if tests are failing.
So I add another heading Pass/Fail and add the formula =IF(B2=C2,"pass","fail") into cell D2.
I quickly overtype cell C2 with “i” to check it works with a pass and it does. Then I put in the word “blah” to check that the fail works and it does too. I undo both of those and play around with Excel’s conditional formatting feature and make “true” show in Green background and “false” show in Red Background.
I now have a testing environment, of sorts, and a passing test.