| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel is there a function to change a cell's background color?
The cell contains a formula to determine the contents. Based upon results, I
would like to color the background of the cell (e.g. if 10 color red; if 10 & <20 color yellow; etc.). I have not been successful in finding a solution using help. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel is there a function to change a cell's background color?
Look in Format/Conditional Formatting
"Sireofsix" wrote: The cell contains a formula to determine the contents. Based upon results, I would like to color the background of the cell (e.g. if 10 color red; if 10 & <20 color yellow; etc.). I have not been successful in finding a solution using help. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel is there a function to change a cell's background color?
Use Conditional Formatting (Format Conditional Formatting): Cell value is
and set your criteria. Click Add to add additional conditions. "Sireofsix" wrote: The cell contains a formula to determine the contents. Based upon results, I would like to color the background of the cell (e.g. if 10 color red; if 10 & <20 color yellow; etc.). I have not been successful in finding a solution using help. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel is there a function to change a cell's background col
Excellent! Thank you very much and have a great day ! ! !
"jirkalla" wrote: Look in Format/Conditional Formatting "Sireofsix" wrote: The cell contains a formula to determine the contents. Based upon results, I would like to color the background of the cell (e.g. if 10 color red; if 10 & <20 color yellow; etc.). I have not been successful in finding a solution using help. Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel is there a function to change a cell's background col
Excellent! Thank you very much and enjoy your day ! ! !
"SVC" wrote: Use Conditional Formatting (Format Conditional Formatting): Cell value is and set your criteria. Click Add to add additional conditions. "Sireofsix" wrote: The cell contains a formula to determine the contents. Based upon results, I would like to color the background of the cell (e.g. if 10 color red; if 10 & <20 color yellow; etc.). I have not been successful in finding a solution using help. Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel is there a function to change a cell's background color?
What nobody has mentioned here is that you must FIRST select the range you want formatted before you can use conditional formatting. I had to search TWICE and experiment for about 10 minutes (with 100% failure rate) to find that out. Too bad MS fails to mention pretty crucial stuff like that right up front, eh? Their help-search algorithm is apalling. Then again, my needs are nothing compared to their deisre for total world domination. Have a good one. Mark Boston -- LTUser54 ------------------------------------------------------------------------ LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459 View this thread: http://www.excelforum.com/showthread...hreadid=533751 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Is there an Excel formula to sum color filled cells? | Excel Worksheet Functions | |||
| background color of my cell does not change | Excel Discussion (Misc queries) | |||
| How do I get excel to add cells by color? Like all green cells (s. | Excel Discussion (Misc queries) | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Linear Mode
