Forum Discussion
CraigCrisp
Oct 17, 2024Copper Contributor
Conditional Formatting - How do I get an entire row to change color based on any date being entered.
How do I get an entire row to change color based on any date being entered into the first cell of the row? I would like to apply this to all rows where only rows with a date in the first cell will ch...
SergeiBaklan
Oct 17, 2024Diamond Contributor
Main question is what else except dates could be in such cells. In Excel dates are actually numbers.
CraigCrisp
Oct 17, 2024Copper Contributor
SergeiBaklan uhm, perhaps letters, words, numerals that are not date formatted; you can even paste photos in a cell if you like. Hope that helps Mr. MVP.