formula for Conditional Formatting of earliest DATE in column.

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
535
Hi again,

I need to figure out what to enter into the Conditional Formatting formula to highlight the earliest date in column W. The data starts at row 14, and ends at row 50 and contains either valid dates or nothing at all. There could be more than one of the "earliest date"

Is this possible? Could someone tell me how to do it? Please don't just say to use the MIN function, I've been trying and couldn't figure out how.

Thanks in advance!

Jennifer
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Sal Paradise

Well-known Member
Joined
Oct 23, 2006
Messages
2,457
Excel Workbook
W
149/11/2006
1510/15/2008
161/6/2006
172/17/2008
18
19
2012/22/2008
21
22
2311/23/2007
2411/27/2008
251/30/2008
266/25/2006
275/11/2006
282/27/2007
297/16/2008
30
31
325/15/2006
336/7/2008
Sheet1


Conditional Formatting:
=W14=MIN(W$14:W$50)
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
Hi

Follow these steps:

Select Conditional Formatting, next in Condition 1, select "Cell Value Is', next select "equal to" in the second dropdown and finally enter this formula in the third box:

=MIN($W$14:$W$50)

Selcect the format you want to highlight the cell before you click on the OK button.

You are done :) enjoy !!
 

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
535
Thank you both. I used Stormseed's approach, because it gave idiot-proof instructions (which I needed) and it WORKED! Thank you so much.

This conditional formatting is pretty cool, I'm going to have to investigate it more thoroughly.

Appreciate the help immensely. Thanks again,
Jennifer
 

Sal Paradise

Well-known Member
Joined
Oct 23, 2006
Messages
2,457
I feel like the idiot, I had no idea you could work Conditional Formatting that way. I always hardcoded in the Cell value as I wrote above. His way is much better.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,673
Messages
5,838,707
Members
430,566
Latest member
ChanchalSingh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top