conditional formatting question

**fujimi-cho** · 10-21-2007, 12:11 AM

Hi,
I have data supplied to me as: 36/40. In this example, 36 is a person's average score & 40 is the most recent score. In a column of such figures, is it possible to have conditional formatting highlight just the highest recent score? I realize the simplest solution is to split these figures into 2 columns, but would rather rather keep them intact if possible.

Fujimi-cho

**VBA Noob** · 10-21-2007, 04:54 AM

Don't think you can with CF.

Here's a macro that bolds the last 2 digits if greater than the first 2 for each cell in your selection

Link on where to add code

Please Login or Register  to view this content.

VBA Noob

**WinteE** · 10-21-2007, 04:59 AM

Hi Fujimi-cho,

This can't be done by just using Excel's Conditional Format option. But with VBA it is possible as you can see in the attached file.

Select the range with scores and click the button.

Succes,
Erik

**VBA Noob** · 10-21-2007, 05:24 AM

I assume you don't want to press a button so try this event macro

You can either open the attached example or right click your sheet tab > select view code and paste in the below. It works on Col A and makes it bold and red ColorIndex 3.

Please Login or Register  to view this content.

VBA Noob

**WinteE** · 10-21-2007, 05:39 AM

You don't take into account the possibility that the scores are < 10 and/or > 99 VBA Noob.

**VBA Noob** · 10-21-2007, 06:43 AM

Thanks WinteE,

Now amended

Please Login or Register  to view this content.

VBA Noob

**fujimi-cho** · 10-21-2007, 04:52 PM

Thanks to VBA Noob & winteE; y'all confirmed my doubts about conditional formatting doing the job. I'll give your suggestions a try!

Fujimi-cho

**daddylonglegs** · 10-22-2007, 03:29 AM

Not necessarily simple perhaps but you could use conditional formatting to format the cell containing the highest most recent score.

Assume your data is in A1:A10, can contain blanks and data of the format x/y where x and y are positive integers.

Select A1:A10 with A1 active cell and use conditional formatting with this formula

=MID(A1,FIND("/",A1)+1,9)+0=MAX(IF(A$1:A$10<>"",MID(A$1:A$10,FIND("/",A$1:A$10)+1,9)+0))

conditional formatting question

LinkBack

Thread Tools

Rate This Thread

Display

conditional formatting question

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions