Use conditional formatting command from the Format Menu Item. You can
specify the threshold and determine the text color from there.

--
Cheers
Nigel



"NathanS" wrote in
message ...

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