PDA

View Full Version : [SOLVED] Need Help with a Conditional Format



stanl
08-10-2016, 02:18 PM
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:

mancubus
08-10-2016, 02:39 PM
how about?

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

Applies to: (for ex)

=$A$1:$AZ$1500

stanl
08-11-2016, 04:37 AM
Thanks, especially helping me over thinking an obvious solution.:hi:

mancubus
08-11-2016, 05:01 AM
you are welcome.

this happens to most of us indeed :)

stanl
08-12-2016, 04:55 AM
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.

mancubus
08-12-2016, 05:54 AM
did you consider using an event 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/excelpivottableconditionalformat.html