Search : in
By :

Background color of cell in Excel

Last answer on Oct 14, 2009 6:58:20 pm BST Dancing Waves, on Dec 17, 2008 8:32:10 pm GMT 
 Report this message to moderators

Hello,
I am trying to write a simple formula that will give me the backgroud color of a cell (in Excel). Something along the lines of, if background color is black, enter text from cell into another cell.

Does anyone have any suggestions?

Thanks

Configuration: Windows XP
Internet Explorer 7.0
Excel 2007

Best answers for « Background color of cell in Excel » in :
White background's problem in web pages ShowYour web pages will be displayed more accurately : No background color, everything is white !!! (Like this image) To resolve this problem follow these steps : 1. Go to the "Control Panel" : Click on "Option accessibility" 2. In the...
[Mozilla Firefox] fonts and colors Show[Mozilla Firefox] fonts and colors It is possible with Mozilla firefox to use a custom background color and fonts (color of your choice), or even change the color of links ... To make these changes: Open Firefox and click on...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Backgrounds ShowAdding a Background Image A background image for a web page can be set using the tag: Attribute Visual Effect BACKGROUND="image" Displays image as background bgcolor="name_of_Colour or #XXXXXX" Displays the given colour...

1

Tiago Magalhães, on Jan 19, 2009 2:31:23 pm GMT
Reply to Tiago Magalhães

2

 Gjagji, on Oct 14, 2009 6:58:20 pm BST

I needed same thing. Here is shortest way I found:
http://www.mrexcel.com/forum/showthread.php?t=37888

Reply to Gjagji