In excel HOME conditional formation one option is there that you can click and apply conditionals for your range. LIke 1-5 green color, 6-8 - black color and 9-10 red color.
In excel HOME conditional formation one option is there that you can click and apply conditionals for your range. LIke 1-5 green color, 6-8 - black color and 9-10 red color.
But not in this case. You have a text instead of numbers and each row text is unique.
Only solution is a formula. Secondly need to color specific prior selected row range FROM-TO which rows to color.
Open attached sample that is added in this thread and sooner or later you will notice the problem.
Thanks again to Glenn for solution. This thread marked as solved completely. A++ grade from me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks