CF help.

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,266
Office Version
  1. 2007
Platform
  1. Windows
Hi,

Im looking for a CF formula that will highlight only the cells that match those 6 values from A1:A6 in the table C1:M6. Thank you.
Serge.


Table2.PNG
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
1,362
Office Version
  1. 2016
Platform
  1. Windows
Hi Serge,

This should work for you:

Serge.xlsx
ABCDEFGHIJKLM
1111222112111
2111122222222
3111122111111
4111122222222
5222122111111
6212212222222
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C1:M6Expression=CONCATENATE($A$1,$A$2,$A$3,$A$4,$A$5,$A$6)=CONCATENATE(C$1,C$2,C$3,C$4,C$5,C$6)textNO
 

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,266
Office Version
  1. 2007
Platform
  1. Windows
Thank you so much Toadstool, It works perfect.
Serge.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,986
Messages
5,621,993
Members
415,873
Latest member
fuulhouse

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top