Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

Excel Conditional Formatting Based On Multiple Cell Values

In an Excel spreadsheet, I want to highlight any cell in the sheet that has the same value as any one of six cells in the first row. i.e. cells A1 through F1.

I will change the values in A1 through F1 daily & need to see if any of the 200 or so other sells in the sheet have the same value.

I thought Conditional Formatting could do it but it won't allow me to target the value of more than one cell, i.e. I can format to say if any of these cells are equal to A1, then highlight the cell, but I cannot say if equal to A1 OR B1 etc..

Any takers? :)
0
snooflehammer
Asked:
snooflehammer
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
The following formula when applied to a range with E4 as the top left corner will format the cell if equal to a value in A1:F1

=COUNTIF($A$1:$F$1, E4)

If have attached an example file for you to look at

Michael
Example.xlsx
0
 
snooflehammerAuthor Commented:
Elegant. Thank you
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now