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
--
NathanS
------------------------------------------------------------------------
NathanS's Profile:
http://www.excelforum.com/member.php...o&userid=26288
View this thread:
http://www.excelforum.com/showthread...hreadid=395718