Question on using formula's with cell formatting.
Say I have a list of companies and all those in red cells are considered 'tech' companies, whereas all those in blue are considered 'health-care' companies.
Can I create a formula in another tab that will give read 'tech' or 'health-care' in a cell based on the other tab's color?
Please see spreadsheet for more clarity.
Thanks!
Bookmarks