| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
