If_Then question

[Giovanna]

I have a workbook with different sheets within the workbook. On my code page
I have a column with client, client code I have assigned to each client. I
have added a column that identifies what type of client. On another
worksheet I have a look up fuction to populate a cell. In addition, to the
look up function I need if the client is X type then the cell changes colors.

 

[Jacob Skaria]

Try conditional formatting. The below link should help

http://www.contextures.com/xlCondFormat01.html