Jack-P-Winner
Member
I have a spreadsheet that depending what happens in column A, cells in GH RS and AC AD will either high light Green in GR AC or red in HS AD. I noticed that I have had a cell high lighted in red forever and when I change the rule from top to bottom the red in the cell went away with no change in column A (its blank)
Why does it matter what position the ruling is in as long as all the rules are in the same position in each cell (all on top as 1st rule or all on bottom as last rule)
Thanks
Why does it matter what position the ruling is in as long as all the rules are in the same position in each cell (all on top as 1st rule or all on bottom as last rule)
Thanks