I am trying to get conditional formatting to highlight the lowest value once it crosses a certain threshold (600000). It won't let me highlight like I want to as it is showing two 'MINs' right now. I've attached an image for reference.
I am trying to get conditional formatting to highlight the lowest value once it crosses a certain threshold (600000). It won't let me highlight like I want to as it is showing two 'MINs' right now. I've attached an image for reference.
Try this:Let me know if you have any questions.Formula:Please Login or Register to view this content.
Edit: I also see (w/ magnification) the problem with the original rule, needs absolute column references as in:Formula:Please Login or Register to view this content.
Last edited by JeteMc; 10-17-2016 at 12:51 PM. Reason: Added Edit
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Or try this
Formula:Please Login or Register to view this content.
Thanks for the rep.
Please, do not forget to mark this thread as SOLVED.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks