Need Help with a Conditional Format

I am using this formula

=AND(INDIRECT("F"&ROW())<5,INDIRECT("I"&ROW())>15)

to apply a conditional color to cells in Column I, so basically if the value in Column F is <5 and the value in Column I >15 I want it colorized. But I get nothing even though rows meet that condition. I think using AND() and INDIRECT() are correct.... dunno

Any help appreciated.:think:

how about?

PHP Code:

---

=AND($F1<5,$I1>15) 


---

Applies to: (for ex)

PHP Code:

---

=$A$1:$AZ$1500 


---

Thanks, especially helping me over thinking an obvious solution.:hi:

you are welcome.

this happens to most of us indeed :)

I should have added the cells were in a Pivot Table, so I needed to add an OR() to account for blank cells and process 2 conditions - basically if a worker was part time then 1 break for 15 minutes and full time = 2x15. I initially thought using Indirect() would limit to the Pivot Range and not the column range as the size and complexity of the full workbook has engendered system resource errors for users.

did you consider using an event code?

Code:

---

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
End Sub

---

i usually don't need to conditional format a pivot table, but i use the above code where necessary and applicable.

non-vba solution, where applicable:
http://www.contextures.com/excelpivo...nalformat.html