Posted to microsoft.public.excel.worksheet.functions

SunshineinFt.Myers[_2_] SunshineinFt.Myers[_2_] is offline

external usenet poster

Posts: 14

Formula not working, help

I am using conditional formatting featu Using the Formula is in the
conditonal formatting: =AND(M3:M5440,M3:M544<"Exempt") This is not working.
Want to highlight those cells that have 0 but do not want to highlight empty
or the cells that have the word exempt. Need some help. Have been trying to
get this answered for a few days now.

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
Formula Not Working	AccAdmin	New Users to Excel	3	June 13th 08 06:00 PM
Formula Sometimes Working Sometimes Not	merry_fay	Excel Discussion (Misc queries)	4	December 6th 06 03:36 PM
Formula not working	Cinderella	Excel Discussion (Misc queries)	1	August 26th 06 11:47 PM
Formula not working	nir020	Excel Worksheet Functions	1	January 23rd 06 06:05 PM
formula is not working	olivia824	Excel Worksheet Functions	2	January 3rd 06 08:03 PM

All times are GMT +1. The time now is 06:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us