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

Conditional Formatting a single cell based on another range [Solved/Closed]

Report
Posts
2
Registration date
Sunday October 20, 2013
Status
Member
Last seen
October 20, 2013
 -
Posts
2
Registration date
Sunday October 20, 2013
Status
Member
Last seen
October 20, 2013
 -
I have been trawling around looking for a solution to my problem.

I need to highlight/colour a single cell when its value appears in a row elsewhere in my spreadsheet.

For example, if the word Breezefree (which resides in cell D:100) appears in row 7, between B7:AD7, I need to highlight/colour cell D:100.

I need to copy the same formula from cell D:100 to D:115, where other key words are contained, including: Daikin UK in D:103, Futurama in D:105 etc... for the entire D:100 - D:115 range. Whilst always searching the same row.

The same rule then needs to be applied to range E:100 to E:115, whilst searching in B8:AD8.

So,

- If the content of D:100 (Breezefree)
- appears in row cells B7:AD7
- I need the formula to Conditionally format the content of D:100 (Breezefree) - with a green background

Please Help

Kind Regards

Hussar
See more

2 replies

Answer 1 / 2
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 16, 2020
 135
Hussar, Good morning.

Select D100 cell.

At CONDITIONAL FORMATTING;

FORMULA --> =MATCH(D100,$B$7:$AD$7,0)

Choose your desired COLOR at Format.

I hope it helps.
Thank you
1
Thank you

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

CCM 2929 users have said thank you to us this month

Answer 2 / 2
Posts
2
Registration date
Sunday October 20, 2013
Status
Member
Last seen
October 20, 2013
Perfect. Thank you very much Mazzaropi

Have a great day

Kind Regards

Hussar
Ask a question