Posted to microsoft.public.excel.worksheet.functions

jenn

external usenet poster

Posts: 107

I need help creating a formula

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a formula	JMP	Excel Worksheet Functions	2	December 8th 06 12:42 PM
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
Creating a complicated formula	Cheryl	Excel Worksheet Functions	3	July 19th 06 12:50 PM
need help creating formula based on cell value	Brad	Excel Discussion (Misc queries)	3	April 1st 05 07:51 PM
Creating a specific formula	booroni	New Users to Excel	3	March 26th 05 10:05 AM

All times are GMT +1. The time now is 09:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us