VBA conditioning formatting & putting in comments programmatically in the whole worksheet

I need help to format the fonts as shown in the attached spreadsheet.

The three columns are Section, EID and AID(Accounting ID)

If Section value is 1 then I want the whole record to be Green

If Section value is 2 then I want the whole record to be Red

If Section value is 3 then I want the whole record to be Blue

Also if the EID is not the same as AID then I want to put the AID in as a comment in EID



Expert Asked on May 3, 2017 in Excel.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.