Conditional formatting with range [Solved/Closed]

Question

Conditional formatting with range [Solved/Closed]

Report

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
Conditional Formatting: 3 range of numbers ✓ - Forum - Excel
Conditional format "match range" ✓ - Forum - Office Software
Conditional Formatting range of date cells based on another cell ✓ - Forum - Excel
Conditional formatting from another cell by range ✓ - Forum - Excel
CONDITIONAL FORMATTING IN EXCEL - off of a range of cells ✓ - Forum - Excel

2 replies

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!

Ask a question

RayH · Accepted Answer · 2015-02-04T17:45:16-0500

Answer 1 / 2

RayH

Posts: 122
Registration date: Tuesday August 31, 2010
Status: Contributor
Last seen: June 20, 2016

24
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

Conditional formatting with range [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!