Excel 2007 Conditional Formatting is not properly using custom formula provided
- by Charles
In Excel 2007, I want to conditionally color a row if it is odd numbered and then vary the coloring depending on if a specific cell (in column E) in that row contains a number (green) or empty(red). E.g. if E15 has a value of 2 and E13 has no entry, I would expect row 15 to be green and row 13 to be red.
My two formulas are:
To color red:
…