Conditional Formatting on past dates

AUNTDEBBIE

Board Regular
Joined
Dec 15, 2010
Messages
60
I would like to use conditional formatting so that if the dates in column c are older than today(current date), I would like them to turn red so that I can track past due accounts.
Thank you very much. :)
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Select column C, go to Home|conditional formatting, New Rule

Select to "use a formula to determine which cells to format"

Enter formula:

=AND(C1<>"",C1<TODAY())

Clcik Format and choose from Font or Fill tab.
 
Upvote 0
Thank you so very much. Can I copy conditional formatting to the rest of the cells in the same column?
 
Upvote 0
Yes, or you can simply change the Applies to range to the range you want to apply it to.
 
Upvote 0
Hello NBVC can you pls help me in below metter


Hi

I have to do daily no's of vlookup and its taking lots of time now i got one code is below but its only doing one vlookup at one time and every time i have to change the range as per requirements so any body have any idea how can i do multiple vlookup in one time and fast way

Sub Macro5()
Range("K1").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC10,Armine!C1:C3,2,0)"
Range("J1").Select
Selection.End(xlDown).Select
Range("K25365").Select
Range(Selection, Selection.End(xlUp)).Select
Selection.FillDown
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.End(xlUp).Select
End Sub



thanks in Advance
Arvind
 
Upvote 0
Arvind,

Please start a new thread with your topic. Please don't hijack other threads.
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

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
Back
Top