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
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,530
Messages
5,602,196
Members
414,513
Latest member
junbuggle

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