Convert formula to work with conditional formatting

[Luke777]

Hi everyone,

I'm a little confused by some conditional formatting that I'm trying to do.

I use the formula

=OFFSET(Content!M3,MATCH(TODAY(),Content!I4:I58,0),0,1,1)

on "sheet1" Cell "H64" - it simply matches today's date with dates in l4:l58 and then gives me the information from relevant cell/row from column M. Yes - there's probably a better way of doing this, but I use offset in this example for other reasons.

Anyway, column N on the sheet called Content contains text which is either "Y" or "N". I wanted to conditionally format Sheet1 row 64 based on so I tried using

OFFSET(Content!N3,MATCH(TODAY(),Content!I4:I58,0),0,1,1)="Y"

but nothing happened.

Any ideas what I'm doing wrong? If I haven't explained it properly, the cell being checked for "Y" needs to move relevant to the date match function.

Are there any better way of doing the same thing?

Sorry if I've not done a very good job of explaining this btw - It's late and I'm fried.

thanks all!

 

[Luke777]

for anyone coming back to this, turns out the answer was

=OFFSET(Content!N3,MATCH(TODAY(),Content!I4:I58,0),0,1,1)="Y"

. No idea why it didn't work before but it does now!