Joe Gieder

Posts: n/a

Using Conditional Format

I'm trying to highlight the cell with the lowest value by using Conditional
Format.
Example..
A3 = 4
b3 = 7
c3 = 3
d3 = 10
I want to highlight C3 but I tried
=MIN(K$3,$BN$3,$BQ$3,$BT$3) in the Formula Is part of Conditional Formating
and it highlights all the values. Can This be done.

TIA Again
Joe

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
conditional format	Julian Campbell	Excel Worksheet Functions	2	December 15th 04 11:59 PM
copy conditional format as ACTUAL format	Dana Zulager	Excel Discussion (Misc queries)	7	December 7th 04 11:02 PM
make a conditional format the default	Fred Evans	Excel Discussion (Misc queries)	3	December 6th 04 05:01 AM
Conditional format	rexmann	Excel Discussion (Misc queries)	4	December 2nd 04 12:01 PM
Copying a conditional format	Meaux	Excel Worksheet Functions	2	November 29th 04 10:19 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us