cell formatting
I would like to format a cell based upon the contents of another cell. The
problem is that the determining cell has five variations - hence I cannot use conditional formatting as this only allows three variations. In total, on a worksheet, I have about 160 cells whose format I wish to change based upon the contents of 160 associated cells on another worksheet. When changing the format, I wish to change forground and background colours. Any help would be much appreciated. Thanks, Simon |
cell formatting
Simon, If you could describe your 5 variations and what you would like the cell formatted as for each it would be helpful. Will each variation produce a unique formatting? If multiple variations will result in the same format, CF may work for you using formulas. Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=504882 |
cell formatting
Without details on desired colors vs values here is a simple sample demo of
how to change the interior color of B1 based upon the value in A1: Sub Macro1() Range("B1").Interior.ColorIndex = Range("A1").Value End Sub 1. enter the macro 2. put a number in A1 (like 36) 3. run the macro The sample can easily be modified to handle alternative mappings and font colors as well. -- Gary's Student "Simon Jefford" wrote: I would like to format a cell based upon the contents of another cell. The problem is that the determining cell has five variations - hence I cannot use conditional formatting as this only allows three variations. In total, on a worksheet, I have about 160 cells whose format I wish to change based upon the contents of 160 associated cells on another worksheet. When changing the format, I wish to change forground and background colours. Any help would be much appreciated. Thanks, Simon |
cell formatting
Steve
Thanks for the reply. I have a column of entries in column C. All entries are integers from 1 to 5. I wish to format Column A based upon the entries in Column C. If the entry in cell C is "1" then format cell in column A background RED forground WHITE. If the entry in cell C is "2" then format cell in column A background GREEN forground BLACK. If the entry in cell C is "3" then format cell in column A background YELLOW forground BLACK. If the entry in cell C is "4" then format cell in column A background BLUE forground WHITE. If the entry in cell C is "5" then format cell in column A background LIGHT GREY forground BLACK. Many thanks Simon Simon, If you could describe your 5 variations and what you would like the cell formatted as for each it would be helpful. Will each variation produce a unique formatting? If multiple variations will result in the same format, CF may work for you using formulas. Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=504882 |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com