| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Coloring Cells
If this is my matrix for accounting... 0.0% = green 0.0/-5.0 % = yellow < -5.0% = red and I want the entire cell surrounding the solution to correlated to the color scheme mentioned above, what function would I use to do that? G -- Gabbi ------------------------------------------------------------------------ Gabbi's Profile: http://www.excelforum.com/member.php...o&userid=25654 View this thread: http://www.excelforum.com/showthread...hreadid=390718 |
|
#2
|
|||
|
|||
|
Use conditional Formatting... -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=390718 |
|
#3
|
|||
|
|||
|
See conditional formatting in help.
Look up 'Highlight cells that meet specific conditions' in the Answer wizard in help -- HTH RP (remove nothere from the email address if mailing direct) "Gabbi" wrote in message ... If this is my matrix for accounting... 0.0% = green 0.0/-5.0 % = yellow < -5.0% = red and I want the entire cell surrounding the solution to correlated to the color scheme mentioned above, what function would I use to do that? G -- Gabbi ------------------------------------------------------------------------ Gabbi's Profile: http://www.excelforum.com/member.php...o&userid=25654 View this thread: http://www.excelforum.com/showthread...hreadid=390718 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
