07-12-2019, 05:51 AM
|
|
Expert
|
|
Join Date: Apr 2014
Posts: 866
|
|
Quote:
Originally Posted by sjp1966
I notice there isnt a $ to the right of the E under rule so does that mean the rule is looking always at column E but the number will change on each subsequent cell, so E4, E5, E6 etc, even though the conditional formatting on each cell only shows E3
|
Yes it does.
|