Thread: Change colour of cell depending on content
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
blain blain is offline
external usenet poster
  
Posts: 1
Default Change colour of cell depending on content

I want to be able to change the background colour of a cell depending on
its content, I could use conditional formatting but I have more than
three conditions.

I have 14 different conditions.

Can someone provide me a generic VBA code to accomplish this.

The content is text rather than a number.

Hope someone can help.


--
blain
------------------------------------------------------------------------
blain's Profile: http://www.excelforum.com/member.php...o&userid=34368
View this thread: http://www.excelforum.com/showthread...hreadid=552591

Reply With QuoteReply With Quote