Not a formula in the cell but Conditional Formatting will do this very well.
Look it up in 'Help'
Regards,
Alan.
"Todd Nelson" wrote in message
...
Two Questioins
1. What is the formula to use when you need cells in a column to switch
text
colors if it is under a certain percentage. i.e. column "o" under 95%

2. Formula to change cell color of adjacents cells to yellow if between
0:06-0:10 seconds, red if over 0:11 seconds? ie. column c 0:07 seconds,
columns a-e = yellow.

thank you!!!