Conditional formatting another cell based on text in a range

Solved/Closed
KB2383
Posts
1
Registration date
Wednesday June 30, 2021
Status
Member
Last seen
June 30, 2021
- Jun 30, 2021 at 02:58 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jul 1, 2021 at 12:20 PM
Hi

I have a spreadsheet where columns A,B,C contain text (a subject studied at school) e.g. Maths, Science, Geography. I have 170 rows of this data, all a different combination of 3 choices from 14 school subjects. I need the cell next to these lists (Column D) to change colour if columns A,B,C contain a certain subject E.g. Column D changes if they have chosen Maths, Column E changes if they have chosen Science etc.

I've found a formula on here which works for one row at a time but it won't work for multiple rows unless I type it in each time. The formula I'm using is =ISNUMBER(SEARCH("Maths",A2:C2))=True

Can anyone help?

TIA!

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jul 1, 2021 at 12:20 PM
Hi KB,

Make sure you have a dollar symbol in front of the column letters in your formula and you have set the right range in the 'Applied range' box.

Best regards,
Trowa
0