return a value based on cell background color
Is there a formula that will return a value based on a cells background color.
I have a spreadsheet that someone has taken the time to highlight changes they want. I want to be able to identify these and be able to filter on them. I assume the easiest way is to assign a value in an adjoining column.
I know I can do this the other way around by using conditional formatting, but don't know if what I want can be done.
Good morning mccardled
Unfortunately, excel doesn't allow you to filter by colour, however Ron de Bruin has taken the time to write a freely available add-in that will allow you to filter by colour. You can download it here :
Please familiarise yourself with the rules before posting. You can find them here.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1