Dear All
Please solution
I want it OK if two cells have the same color; if not, I want to check.
Dear All
Please solution
I want it OK if two cells have the same color; if not, I want to check.
1. Ctrl+F3,
2. New -> Name: Color1 Refers to:=GET.CELL(63,INDIRECT("rc[-2]",0))
3. New -> Name: Color2 Refers to:=GET.CELL(63,INDIRECT("rc[-1]",0))
4. E8 =IF(Color1=Color2,"ok","check")
copied down.
5. save as .xlsm file
Thank you so much
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks