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!