I'm struggling to work out how to highlight a cell if it's value is more/less than x AND it is a certain color.
How do I get Excel to recognise the color of the cell?
I'm struggling to work out how to highlight a cell if it's value is more/less than x AND it is a certain color.
How do I get Excel to recognise the color of the cell?
Select The range
Press Alt + O + D
Click New Rule
Select Format Only Cells That Contain
Rest you can decide from the below drop downs from which you can select your desired options
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks