MOD(ROW(),2) Function with a Formula

[tykc17]

Is there a way to have a sheet have the alternating rows but have a formula within it so I don't have to do double the work?

I want to color every other row but one of the formatting options I do is a fade from my XLOOKUP or dropdown menu in the overall status and I want the white rows to have a fade from Yellow to White and t gray to Yellow to gray. I've tried playing around with putting my XLOOKUP into it and it doesn't seem to like it.

 

[JamesCanale]

I don't know if this will all come out in the xl2bb

MrExcelPlayground23.xlsx
	A	B
1	1	a
2	2	b
3	3	c
4	4	d
5	5	e
6	6	f
7	7	g
8	8	h
9	9	i
10	10	j
Sheet14

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B10	Expression	=ISODD(ROW(B1))	text	NO
B1:B10	Expression	=ISEVEN(ROW(B1))	text	NO
A1:A10	Expression	=ISEVEN(ROW(A1))	text	NO

edit. It didn't. The rules are there, but the formatting has

 

[dreid1011]

Something like this?

Book1
	A	B	C	D	E	F
1						AWAITING APP
2						AWAITING APP
3						AWAITING APP
4						AWAITING APP
5						AWAITING APP
6						AWAITING APP
7						AWAITING APP
8						AWAITING APP
9						AWAITING APP
10						AWAITING APP
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F1:F10	Expression	=AND(MOD(ROW(),2)=0,F1="AWAITING APP")	text	NO
F1:F10	Expression	=AND(MOD(ROW(),2)=1,F1="AWAITING APP")	text	NO
A1:F10	Expression	=MOD(ROW(),2)=0	text	NO

Guess XL2BB doesn't like gradients.

 

[tykc17]

That is what I was trying to do thank you

 

[dreid1011]

That is what I was trying to do thank you

You're welcome, and happy to help.