Ask Your Question

Match Cells conditional format background.

asked 2018-09-16 19:28:19 +0200

JG101 gravatar image

updated 2018-09-23 17:01:03 +0200

Please need help with Match Cells conditional format, please see attached file for example : How do I color background in G23 when it matches EXACT number in ROW M8:M17

C:\fakepath\Match Conditional Formating Match Cell 09-16-2018.ods

edit retag flag offensive close merge delete


M8:M17 isn't ROW. Please write your question more clear

kompilainenn gravatar imagekompilainenn ( 2018-09-17 06:58:51 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-09-17 07:16:16 +0200

mahfiaz gravatar image

Use the following formula for conditional formatting: =MATCH(G23;$Sheet1.$M$8:$M$17;0)

edit flag offensive delete link more


Thank you for the reply, I'm looking to change the background color when column G numbers match column M

This script shows only numbers that match and omits everything else.

I have a set of numbers in Column G & M, if G matches numbers in M then the background cell will change color

This is what i need. changing background

I found a work around but I have to create a conditional formatting for each cell G23 = M8 color green G23 = M9 color green . . . .

JG101 gravatar imageJG101 ( 2018-09-21 16:10:25 +0200 )edit

Are you looking for $G$23=M8 ?

mahfiaz gravatar imagemahfiaz ( 2018-09-26 11:39:00 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-16 19:28:19 +0200

Seen: 98 times

Last updated: Sep 23 '18