Sorry if this is simple for you I am new to programming in Excel.

=AND(Cell>0.799999,MOD(ROW(),2)<>0)

I have been using a formula simular to the one above...

I want to have alternating background colors and if the number is equal to or over 80% I want the text to turn red.

How can I do this?

I have figured out how to use "=MOD(ROW(),2)<>0)" and
=Cell is >0.799999

but I want to combine them.

Thanks for your help,
Nathan