bananatang
08-11-2009, 06:18 AM
Hi,
Need further assistance please...........
I have a summary sheet which lists pupils names. Each pupil has a separate worksheet and the worksheet is called the pupils name.
I am trying to conditional format column E in the summary sheet, starting from Row 14. The cell which i want the conditional format to look at is in the pupils named worksheet at U13.
The Pupils name is listed in the summary sheet at Column C, Row14
The vba code will need to look at column C Row14 in the summary sheet starting from for the pupils name and then goto the pupil named worksheet. Check to see if cell U13 is populated, and if it is i would like the cell in Column E in the summary sheet, adjacent to the pupils name to go to Red if populated and Green if not.
The pupil list will increase over time, thus the vba code will need ensure that it captures all the pupils.
I have attached a sample of the document for easier understanding of the issue i am trying to solve.
Many Thanks
BT
Need further assistance please...........
I have a summary sheet which lists pupils names. Each pupil has a separate worksheet and the worksheet is called the pupils name.
I am trying to conditional format column E in the summary sheet, starting from Row 14. The cell which i want the conditional format to look at is in the pupils named worksheet at U13.
The Pupils name is listed in the summary sheet at Column C, Row14
The vba code will need to look at column C Row14 in the summary sheet starting from for the pupils name and then goto the pupil named worksheet. Check to see if cell U13 is populated, and if it is i would like the cell in Column E in the summary sheet, adjacent to the pupils name to go to Red if populated and Green if not.
The pupil list will increase over time, thus the vba code will need ensure that it captures all the pupils.
I have attached a sample of the document for easier understanding of the issue i am trying to solve.
Many Thanks
BT