Forum Discussion
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 change colors.
11 Replies
Main question is what else except dates could be in such cells. In Excel dates are actually numbers.
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.
Formulas in Excel, includes one used in conditional formatting, works with cell values, not with properties like formats.
Other words, if we have 25 in A1 and Jan 25,1900 in B1, =A1=B1 returns TRUE since both cells have exactly the same value, even if formatted differently.
If no other logic to separate numbers which are not considered as dates, afraid that's with VBA programming.
