Conditional Formatting issue

[DanMastro]

I'm trying to highlight a row (columns 1-5) in a color based on two criteria:

1. The cell in column 1 of the previous row must not be blank.
2. The cell in column 5 of the current row must be blank.

Here is what I have put in as a formula:

=AND(NOT(ISBLANK(OFFSET(INDIRECT("R"&ROW()&"C"&"1",FALSE),-1,0))),ISBLANK(INDIRECT("R"&ROW()&"C"&"5",FALSE)))

When I plug this into a cell, it returns TRUE or FALSE as it should. I've tested it multiple times and it's fine, but no cells ever get highlighted.

Somebody please help!

 

[DanMastro]

I should clarify by saying that when I plug the formula into a cell, it works, but when I put it into the conditional formatting box, it doesn't.

 

[DanMastro]

I figured it out myself! If anyone else experiences issues with this, fix it by removing the "Row()" items. The INDIRECT function works if you just omit the numbers using the R1C1 approach. Example:

INDIRECT("RC1", FALSE) - will return the cell in row 1, column 1
INDIRECT("RC5", FALSE) - will return the cell in row 1, column 5