Need help with a formula or a macro

dimka

New Member
Joined
May 24, 2004
Messages
45
I need a formula or a macro the would give me the fallowing results

i have a column with dates, what i need is , if at any month the date is greater then the 15th highlighte the entire row.


Thank you for your help
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,056
Office Version
  1. 365
Platform
  1. Windows
Why not use conditional formatting?

Select the entire range.

Goto Format>Conditional formatting, select Formula is and enter something like this

=DAY($A1)>15

Then format as required.

Change A to reflect the column with the date and you might have to change the 1 to deal with headers or if the data starts on a different row.
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
create a conditional format
highlight a rows you need and select format - conditional format
change to formula is and put in this formula
=DAY($F1)>14

adjust F1 to cell where you have the date. Then put in a format for true condition.
 

dimka

New Member
Joined
May 24, 2004
Messages
45
thats good, but i need entire row to be highlighted and its a column of dates not just one date
 

farnuckl

Board Regular
Joined
Dec 16, 2003
Messages
127
Yes, just follow Norrie's instructions and it will work just like you want.

-farnuckl
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,056
Office Version
  1. 365
Platform
  1. Windows
Well like I said select the entire range/row.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,323
Messages
5,571,544
Members
412,402
Latest member
xam99
Top