Excel macro for if condition (format)

**Rofiudden Ahmed** · 09-17-2012, 04:16 PM

Hello everyone,
I need a macro based on condition, if cell A1 is between 8.30 pm to 8.45 Pm then Cell A1 should higlighted

**Special-K** · 09-17-2012, 07:43 PM

You dont need a macro, you need Conditional Formatting

Select A1
Condtional Formatting
New Rule
"Use a formula to determine..."
=(AND(A1>=TIMEVALUE("20:30:00"),A1<=TIMEVALUE("20:45:00")))
highlight as required

Use Format painter to paste to other cells if needed

**Rofiudden Ahmed** · 09-18-2012, 04:09 PM

Thanks a lot for your reply.... But conditional formula doesn't work since cel "A1" is contain a time formula "=Now()". Can pleaese help me out ...

**Rofiudden Ahmed** · 09-18-2012, 04:16 PM

Acctually we need to perform some particular task on required time , it will be great if any one can provide a macro which will give a pop-up message , Suppose time is between 8:30 PM to 8:50 PM.