EXCEL help needed - format within conditional formatting

[Joebob]

I'm struggling with something in Excel and need a little help if possible.

In the above spreadsheet I am trying to use Conditional Formatting to make the cells grey out once the date and time have passed.

I can make them grey out after the date but I'm struggling with the time.

Any help really appreciated.

 

[dazzerd]

I'm struggling with something in Excel and need a little help if possible.

In the above spreadsheet I am trying to use Conditional Formatting to make the cells grey out once the date and time have passed.

I can make them grey out after the date but I'm struggling with the time.

Any help really appreciated.

wont =if(and($j$4<today(),$j$5<now()),1,0)

entered as a formula in conditional formatting.

 

[Makhaira]

Check if the A cell is <NOW()

Job done

 

[Joebob]

I'm afraid that neither of the above solutions work.

 

[james.miller]

I'm struggling with something in Excel and need a little help if possible.

image removed

In the above spreadsheet I am trying to use Conditional Formatting to make the cells grey out once the date and time have passed.

I can make them grey out after the date but I'm struggling with the time.

Any help really appreciated.

=if(and(b$1<$j$4,$a3<$j$5))

try that, or, uploade the sheet so we can have a go


edit:

its actually this:

=OR(B$1<$J$4,(AND(B$1<=$J$4,$A3<$J$5)))

entered as the conditional format for the range. this works providing the times are entered on the sheet as values and not text. Take a look at the link below to see how i did it. If you add a day to cell J4 then you'll see it working. hope that helps!

http://www.mediafire.com/?olb5l24z4uhgiup