conditional formatting problems

JRolph · Mar 8th, 2002, 04:12 PM

I used the formula =AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)in conditional formatting to find and highlight the single lowest number in a column. This worked fine in my test sheet. When I used it in another workbook it did nothing in one column and would only highlight ones or zeroes in the others.

"WHAT HAPPENED?"

Mark W. · Mar 8th, 2002, 04:16 PM

Funny, you should ask!!! The same thing happened to me while I was verifying a response to your posting yesterday. As a result someone else "beat me to the punch". Later, I tried it again on a fresh worksheet and it worked like a charm.

Brian from Maui · Mar 8th, 2002, 04:55 PM

Mark,

I've been following this thread as I plan to use this in using it in a "skins" game. Do I format this before I enter scores or is there someway I can format it "after" scores are entered?

Brian

Mark W. · Mar 8th, 2002, 04:57 PM

Quote:

On 2002-03-08 15:55, Brian from Maui wrote:
Mark,

I've been following this thread as I plan to use this in using it in a "skins" game. Do I format this before I enter scores or is there someway I can format it "after" scores are entered?

Brian

Either way.

JRolph · Mar 8th, 2002, 07:10 PM

Brian;
I am developing a "skin game" sheet also. I have all the formulas for deducting strokes on the handicap side as I enter the scratch scores on the scratch side.

Brian from Maui · Mar 8th, 2002, 07:24 PM

JR

I'm just developing one now. I have a program from GHIN, but thought of making one myself.

Brian

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 04:12 PM	#1
JRolph New Member Join Date: Mar 2002 Posts: 14	I used the formula =AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)in conditional formatting to find and highlight the single lowest number in a column. This worked fine in my test sheet. When I used it in another workbook it did nothing in one column and would only highlight ones or zeroes in the others. "WHAT HAPPENED?"

Mar 8th, 2002, 04:16 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Funny, you should ask!!! The same thing happened to me while I was verifying a response to your posting yesterday. As a result someone else "beat me to the punch". Later, I tried it again on a fresh worksheet and it worked like a charm.

Mar 8th, 2002, 04:55 PM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Mark, I've been following this thread as I plan to use this in using it in a "skins" game. Do I format this before I enter scores or is there someway I can format it "after" scores are entered? Brian

Mar 8th, 2002, 07:10 PM	#5
JRolph New Member Join Date: Mar 2002 Posts: 14	Brian; I am developing a "skin game" sheet also. I have all the formulas for deducting strokes on the handicap side as I enter the scratch scores on the scratch side.

Mar 8th, 2002, 07:24 PM	#6
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	JR I'm just developing one now. I have a program from GHIN, but thought of making one myself. Brian