I know this is a bit of a misleading title, but this is basically what I searched when I was trying to find this solution...but you will be effectively using conditional formatting much in the same way that if/then statements are formatted