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.
- 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
Conditional Formatting a single cell based on another range