Might be time to read a book - forgive the four-lettered word.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jenn" wrote in message
...
I need to create a conditional formula that says:
If cell is < 500,000 color the cell bright green
If cell contains "n/a" or "4%" do not change format
I've tried entering them each as a condition but that's obviously not
working.

I need major help with formulas.
Can anyone refer me someplace where I can get help with learning to create
formulas?
Thanks a bunch!