Convert formula to work with conditional formatting

Luke777

New Member
Joined
Aug 10, 2020
Messages
24
Office Version
  1. 2007
Platform
  1. Windows
Hi everyone,

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

I use the formula
Excel 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
Excel Formula:
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!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Luke777

New Member
Joined
Aug 10, 2020
Messages
24
Office Version
  1. 2007
Platform
  1. Windows
for anyone coming back to this, turns out the answer was
Excel Formula:
=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!
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,118,269
Messages
5,571,225
Members
412,372
Latest member
JON_ROCKS
Top