Posted to microsoft.public.excel.worksheet.functions

PeterH

external usenet poster

Posts: 20

Conditional Formating

I am not having any success at this, I have 5 cells with figures:-
G5=1
J5=14
M5=0
P5=15
S5=2
I want to highlight in a colour & bold the lowest figure, not oncluding anym
zeros,
I am trying =$G6=MIN(IF(OR(G6,J6,M6,P6,S6)0,OR(G6,J6,M6,P6,S6 )))
Need help, Please.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Conditional Formating	Emece	Excel Discussion (Misc queries)	3	March 1st 09 05:55 PM
conditional formating with len	doyree	Excel Discussion (Misc queries)	7	February 7th 08 11:20 PM
Conditional formating	david	Excel Discussion (Misc queries)	1	July 25th 07 10:43 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional Formating	kpekarek	Excel Worksheet Functions	2	August 17th 05 03:41 PM

All times are GMT +1. The time now is 09:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us