Excel forums question.xlsx
I have the following issue. From the attached I want to be able to have one cells border change to a different color so it is easy to see.
On the attachment if the Pretreatment calcium is 5.5 and the Na+Mg is 2.5 then I want the cell which is now in blue(j21) to change its border color.
The reason I want just the border color changed is because I have four different fill colors in the cells on the chart. This chart does not have the fill colors on it though.
Or any other way to easily find the number on the chart without going down and across the axis.
Bookmarks