Excelguru87
New Member
- Joined
- Aug 17, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
On sheet 1 there are multiple columns and rows which have been colour coded. Is there a way on sheet 2 to return a cell value based on a certain colour? For example if cell a1 on sheet 1 is green I want cell a1 on sheet 2 to return that data, but be blank if it was any other colour?
I cant think of a way to filter multiple rows and columns by colour so wondered if the above was possible?
I cant think of a way to filter multiple rows and columns by colour so wondered if the above was possible?