Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have my headings as blue since "Frog" is chosen. And when "Frog" is not chosen, the table headings change to green:
=if([Frog/Bug]='Frog',RGB (30,144,255),RGB (124, 252,0))
However, I want my rows to alternate grey and light grey, regardless of if "Frog" is chosen or not. How do I make it look like below?
Frog
Ok, good to know..
I used the formula you recommended. It looks a little funky though. Any ideas?