My conditional formatting only works in the first cell of the series, or the entire series changes based on one cell change. I cannot figure out what is wrong! Below I describe how I set up the CF. Please help!
I use Excel 2010.
I want an empty cell in Row E to shade red if, from...