| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Negative and colour change
I currently have a worksheet totaling up an amount of points (I.E. john saw
10 people and his point for this are 5) this is done over several key points and then totaled at the bottom of the row with a SUM. Now I need to add to this sum the issue of a negative number until it reaches 160 points and it needs to be red in colour and changing to blue after 160 point is reached. Thank you ahead of time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the colour of the "invert if negative" option in Excel | Charts and Charting in Excel | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Colour negative border differently | Charts and Charting in Excel | |||
| How to Blink a cell in Excel if negative or red colour | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
![Old_skills_lost[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
