Hello together,
I am currently creating an Excel list which shows the deviations from given values. However, I would like to highlight the line with the deviations in colour but only the largest deviation from the actual target value.
Problem:
In Cell F i have have the given values e.x. 73,6 in 6 lines
And in cell I i have the values from me in a range of 70,7-75,6 in 6 lines.[table="width: 500, class: grid, align: left"]
F: I:
Given Values: Deviation:
73,6 70,7
73,6 71,7
73,6 75,6
73,6 74,6
73,6 73,4
73,6 78,5
Now it should mark in a colour the line with the highest deviation from my given values (cell F).
With conditional formatting i am only capable of given a fix range of the deviation but it's not good if i even change the given values in cell F.
Someone has any solution here?
Have a nice day and thank you in advance!
Greetings,
Daniel
Bookmarks