Conditional Formating , Proper Formulas?

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
hello all, thanks for your help on the last one. I have a new one now. How would i write the following for a conditional Format

if cell value is equal to any of the values in cells a1,a2,a3,a4,a5,d1,d4,d5
Then the format will be applied to the matching cells

Thanks
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

In A1 enter the conditional format, fomula is

Code:
=COUNTIF($A$1:$A$5,A1)+COUNTIF($D$4:$D$5,A1)+COUNTIF($D$1,A1)>1

and the format required.

Copy the cell, and paste format to the other cells (A2:A5,d1,D4:D5)


HTh

Tony
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,955
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
In acw's formula change the >1 to >0 or drop that part completely.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,816
Messages
5,525,064
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top