I want to change the color of a cell based on the value of another cell, I am aware of how to do that in Conditional Formatting. I want to have C1 & D1 to be Red if D1 is greater than C1 but I do not want any color change if C1 is blank and D1 is greater than C1. I cannot seem to figure out how to do this with Conditional Formatting or if it is even possible. Any help will be appreciated.
Bookmarks