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.
how about?
Applies to: (for ex)PHP Code:=AND($F1<5,$I1>15)
PHP Code:=$A$1:$AZ$1500
PLS DO NOT PM; OPEN A THREAD INSTEAD!!!
1) Posting Code
[CODE]PasteYourCodeHere[/CODE]
(or paste your code, select it, click # button)
2) Uploading File(s)
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.
3) Testing the Codes
always back up your files before testing the codes.
4) Marking the Thread as Solved
from Thread Tools (on the top right corner, above the first message)
Thanks, especially helping me over thinking an obvious solution.
you are welcome.
this happens to most of us indeed
PLS DO NOT PM; OPEN A THREAD INSTEAD!!!
1) Posting Code
[CODE]PasteYourCodeHere[/CODE]
(or paste your code, select it, click # button)
2) Uploading File(s)
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.
3) Testing the Codes
always back up your files before testing the codes.
4) Marking the Thread as Solved
from Thread Tools (on the top right corner, above the first message)
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?
i usually don't need to conditional format a pivot table, but i use the above code where necessary and applicable.Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) End Sub
non-vba solution, where applicable:
http://www.contextures.com/excelpivo...nalformat.html
PLS DO NOT PM; OPEN A THREAD INSTEAD!!!
1) Posting Code
[CODE]PasteYourCodeHere[/CODE]
(or paste your code, select it, click # button)
2) Uploading File(s)
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) (multiple files can be selected while holding Ctrl key) / Upload Files / Done
Replace company specific / sensitive / confidential data. Include so many rows and sheets etc in the uploaded workbook to enable the helpers visualize the data and table structure. Helpers do not need the entire workbook.
3) Testing the Codes
always back up your files before testing the codes.
4) Marking the Thread as Solved
from Thread Tools (on the top right corner, above the first message)
Posting Permissions
Reply With Quote