Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Conditional formatting with range [Solved/Closed]

Report
Posts
4
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
March 7, 2015
 -
Posts
4
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
March 7, 2015
 -
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?
See more

2 replies

Answer 1 / 2
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 24
Thanks to rizvisa1 for the solution to this:

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


Thank you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2955 users have said thank you to us this month

Answer 2 / 2
Posts
4
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
March 7, 2015
Thanks!
Ask a question