Conditional formatting with range

Solved/Closed

MindTwister Posts 4 Registration date Wednesday February 4, 2015 Status Member Last seen March 7, 2015 - Feb 4, 2015 at 03:35 PM
MindTwister Posts 4 Registration date Wednesday February 4, 2015 Status Member Last seen March 7, 2015 - Feb 10, 2015 at 02:12 PM

Hello,

I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out.

Here is an example and the file:

If a number in A1:A12 equals to a number in D4:P10 then color the matching cell in the range (D4:P10) in red

https://authentification.site/CBcGg/Range.xlsx

Any help?

Conditional formatting with range
Excel conditional formatting if another cell contains specific text - Excel Forum
How to clear formatting in excel - Guide
Apple airtag range - Guide
Selection.autofill destination:=range ✓ - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum

2 responses

Answer 1 / 2

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 4, 2015 at 05:45 PM

Thanks to rizvisa1 for the solution to this:

https://ccm.net/forum/affich-444020-conditional-format-match-range

Answer 2 / 2

MindTwister Posts 4 Registration date Wednesday February 4, 2015 Status Member Last seen March 7, 2015
Feb 10, 2015 at 02:12 PM

Thanks!

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional formating - apply on more cells

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!