Excel Experts Quiz

Question 1 of 13

To format alternate rows of a table with different colours, you'd use the following for your conditional formatting formula:

=IF(INT(ROW()/2)>1,TRUE,FALSE)

=MOD(ROW(),2)=1

=IF(ISERROR(MOD(ROW(),1)),TRUE,FALSE)

=MOD(ROW(),1)=2

=IF(ROW()=2,TRUE,FALSE)