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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

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,931
Messages
5,621,663
Members
415,849
Latest member
PhoenixRising2015

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