ajaysnarp
06-07-2012, 05:38 AM
Dear Expertise,
Currently I am working on one project & I am stuck in creating a loop & I have been not able to fine a solution.
It would be of great help if anyone can help me on this with there expertise knowledge.
Please find below a summary on the same.
I have attached a sample spreadsheet in which I have already started working in Sheet1 wherein the raw data is also present.
In the row number there are 7 command buttons out of which I have completed the 5 & the Big 2 are remaining for which I need help.
The completed ones are:-
Mandatory Pass: - when I click on this command button it looks in Column H whether it is Y if so it goes & looks in column A to see whether it is PASS. If it is PASS then it will highlight in GREEN.
Mandatory Fail: - when I click on this command button it looks in Column H whether it is Y if so it goes & looks in column A to see whether it is FAIL. If it is FAIL then it will highlight in RED.
Optional Pass: - when I click on this command button it looks in Column H whether it is N if so it goes & looks in column A to see whether it is PASS. If it is PASS then it will highlight in GREEN.
Optional Fail: - when I click on this command button it looks in Column H whether it is N if so it goes & looks in column A to see whether it is FAIL. If it is FAIL then it will highlight in RED.
The Pending Ones for which I need help are:-
Highlight Pass: When I click on this button it should first look into Column B i.e. Profile (for example a1b1 is the first profile we have & there are 3 rows), for any given profile All Y should have a PASS & atleast one of the N also should have a PASS & then enter profile is considered as PASS.
Highlight Fail: When I click on this button it should first look into Column B i.e. Profile (for example a1b1 is the first profile we have & there are 3 rows), for any given profile atleast one Y should have a FAIL & all N should have a FAIL & then enter profile is considered as FAIL.
I have manually updated in Column I what should be the actual result for that particular profile & please note that in my original sheet this column will not be there.
Just as an FYI I have also created two tabs "after hitting Highlight Pass" & "after hitting Highlight Fail" which contains the expected results from the Sheet 1.
Kindly request to help me out in getting a solution for the Highlight Pass & Highlight Fail.
Hope I would get some help from this expertise forum & also please let me know If in case for any other information required from my end.
Thanks a lot for all your help & time in advance!!
Currently I am working on one project & I am stuck in creating a loop & I have been not able to fine a solution.
It would be of great help if anyone can help me on this with there expertise knowledge.
Please find below a summary on the same.
I have attached a sample spreadsheet in which I have already started working in Sheet1 wherein the raw data is also present.
In the row number there are 7 command buttons out of which I have completed the 5 & the Big 2 are remaining for which I need help.
The completed ones are:-
Mandatory Pass: - when I click on this command button it looks in Column H whether it is Y if so it goes & looks in column A to see whether it is PASS. If it is PASS then it will highlight in GREEN.
Mandatory Fail: - when I click on this command button it looks in Column H whether it is Y if so it goes & looks in column A to see whether it is FAIL. If it is FAIL then it will highlight in RED.
Optional Pass: - when I click on this command button it looks in Column H whether it is N if so it goes & looks in column A to see whether it is PASS. If it is PASS then it will highlight in GREEN.
Optional Fail: - when I click on this command button it looks in Column H whether it is N if so it goes & looks in column A to see whether it is FAIL. If it is FAIL then it will highlight in RED.
The Pending Ones for which I need help are:-
Highlight Pass: When I click on this button it should first look into Column B i.e. Profile (for example a1b1 is the first profile we have & there are 3 rows), for any given profile All Y should have a PASS & atleast one of the N also should have a PASS & then enter profile is considered as PASS.
Highlight Fail: When I click on this button it should first look into Column B i.e. Profile (for example a1b1 is the first profile we have & there are 3 rows), for any given profile atleast one Y should have a FAIL & all N should have a FAIL & then enter profile is considered as FAIL.
I have manually updated in Column I what should be the actual result for that particular profile & please note that in my original sheet this column will not be there.
Just as an FYI I have also created two tabs "after hitting Highlight Pass" & "after hitting Highlight Fail" which contains the expected results from the Sheet 1.
Kindly request to help me out in getting a solution for the Highlight Pass & Highlight Fail.
Hope I would get some help from this expertise forum & also please let me know If in case for any other information required from my end.
Thanks a lot for all your help & time in advance!!