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...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
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¯+...
Download WorldTimer ShowWorldTimer is a custom worldwide clock which can show a certain some number of of clocks in different time zones. It is also possible to change the face of the clock and time zone for each clock, the background color, as well as the text color as...
Download Efficient Sticky Notes Show
Download Font Matching Tool Show
Ask your question Reply

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
Ask your question Reply
They need your help