Apply conditional formatting to multiple cells

I'm looking for a fast solution to apply conditional formatting to multiple cells

For example if A1=1 fill row 1 green, now i want to apply that to A2,A3,... only that checking for values at A2 and so on. Is it a fast way to do this except from copying the formula and change the data

So your CF rule, applied to A1, is this:

=A1=1

Now add the range to the Applies To box: =$A$1:$A$100 (or whatever the range is).

Excel will take care of the rest.

No, I did not miss the point at all. I use CF all the time.

The Applies To box allows you to set a range. Excel will then interpret the rule for each row in the range. Try it.

Better still: look at the attached, and then tell me I've missed the point.

Yes, that is EXACTLY what it does. All you need to do is fill in the range in the rule for cell A1.

This is done with ONE rule set for A1 and the Applies To box filled in as I advised:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A
1	1
2	2
3	2
4	2
5	1
6	1
7	1
8	2

Sheet: Sheet1

Only one of us is misunderstanding, and I don't think it's me. How about providing a workbook mocked up with what you are trying to describe?

If you want rows, then the rule is this:

=$A1=1

and the Applies To box is this: =$A$1:$D$100

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D
1	1	x	y	z
2	2	x	y	z
3	2	x	y	z
4	2	x	y	z
5	1	x	y	z
6	1	x	y	z
7	1	x	y	z
8	2	x	y	z

Sheet: Sheet1

Thre you go - would have been SO much easier if you'd provided a sample workbook with a mock-up instead of trying to describe it.