If_Then question
 

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.

If_Then question
 

Try conditional formatting. The below link should help

http://www.contextures.com/xlCondFormat01.html
--
If this post helps click Yes
---------------
Jacob Skaria


"Giovanna" wrote:

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.