conditional formatting gremlins!

$A1="often" is not a formula, but only text. Please try

Formula:

Please Login or Register  to view this content.

Excel does not change that.

does your worksheet actually have single quotes?

Welcome to the forum.

There is no format set in the third one. T8 is probably being affected by another rule. But you aren't setting the rules efficiently, so ...

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

There is no format set in the third one. T8 is probably being affected by another rule. But you aren't setting the rules efficiently, so attach a workbook.

I've removed your rules and applied three new ones:

RED: =AND($P5<>"",$I5="often")
AMBER: =AND($P5<>"",$I5="sometimes")
GREEN: =AND($P5<>"",$I5="not at all")

These each apply to: =$P$5:$R$25

You can set up similar rules for other blocks of three - shout if you need help.

The point is that you only need one rule for the entire range, not one rule per row.

Select cell P5, open the CF dialog and have a look. I can help set up another block for you if you need help.

If you want this sort of thing, then you will need NINE rules per block (see attached):

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
5	not at all		sometimes		often		not at all					DYSLEXIA
6	often		often		often		sometimes					DYSLEXIA
7	often		not at all		often		often					DYSLEXIA
8	often		often		not at all							DYSLEXIA
9	often		often		sometimes							DYSLEXIA
10	sometimes		often		often							DYSLEXIA
11	often		often		often

Sheet: Prim_Part A