conditional format for background color change with cells D47 and D52 when they match

atcman

Board Regular
Joined
May 13, 2005
Messages
57
Ive tried all the conditional formats I could find which indicated they would work but none have. Thanks for the help, I'd be lost without this site. thanks again, ATCMAN
 

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.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,445
Office Version
  1. 365
Platform
  1. Windows
Just use the Conditional Formatting formula:
=$D$47=$D$52
and choose your formatting color.

You would so the same thing for both cells.
 

atcman

Board Regular
Joined
May 13, 2005
Messages
57
Thanks Joe4. I want to say I tried that but will try it. If it works will I be able to fill right?
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,445
Office Version
  1. 365
Platform
  1. Windows
I want to say I tried that but will try it.
If you simply want to check if the two cells are equal, that will work. It is pretty straightforward.

If it works will I be able to fill right?
Not sure what you mean by this statement.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,808
Messages
5,524,995
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top