Need help with a formula or a macro

[dimka]

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

 

[Norie]

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]

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]

thats good, but i need entire row to be highlighted and its a column of dates not just one date

 

[farnuckl]

Yes, just follow Norrie's instructions and it will work just like you want.

-farnuckl

 

[Norie]

Well like I said select the entire range/row.