| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with cell shading
Select all the cells, starting at let's say A2
Menu FormatConditional Formatting Change Condition 1 to Formula Is Add formula of =A2.01 Click Format Select Pattern tab Select red OK Click Add Change Condition 1 to Formula Is Add formula of =A2<-.01 Click Format Select Pattern tab Select green OK OK -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Mark J" wrote in message ... If a table like this Var00 860% 2518% -40% 60% 8% I want to color the cell red when they are 10% positive And green if they are when they are < 10 negative -- Mark J ------------------------------------------------------------------------ Mark J's Profile: http://www.excelforum.com/member.php...o&userid=30738 View this thread: http://www.excelforum.com/showthread...hreadid=504376 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell shading issue on EXCEL 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
