Nevermind. I just found out if I set the default cell format to that of my 4th condition, it will remember it if/when the cell value changes.
Thanks for all the help!