Excel help please

Enrol on a college computer course, halfwit....

On the Excel Home Page, click on Conditional Formatting.
You want the Highlight Cell Rules, it is pretty straightforward from there.
This is for Excel 2007, other versions will be very similar.

There's a better way than that without using conditional formatting. If you press ctrl+1, then in advanced formatting settings there are some with red negatives.

Or in custom format:


1. Park on the cell , say B5
2. press Ctrl+1 to see the format
3. select Custom
4. select #,##0;[Red]-#,##

This was from the first google result for 'excel red negative' so you should ask yourself what you're doing wrong on the internets not to find it.

Or create a custom button in your toolbar with this code so you only need to click the button:

sub highlight_in_red
this_row = 3
Do Until Cells(this_row, 4) = ""
    If Cells(this_row, 4) < 0 Then Cells(this_row, 4).Font.ColorIndex = 3
    this_row = this_row + 1
Loop
end sub

WTF? Code? That's a really **** way to do it.

You don't need any fancy customisation for this, it's a simple option in the ctrl+1 format box.

Format > Numbers; Then format code [$£-809]#,##0.00;[RED]-[$£-809]#,##0.00, or just select currency and tick the "negative numbers red" box.

WTF?!

You only have to write the code once. Then for each P and L download it's just one click instead of all that rigmarole.

There's no rigmarole. And your code doesn't solve it, it has to be run each time, and if it's a calculated field it won't automatically change based on the result.

Formatting a square so it's red if negative is just a freaking option in the formatting menu. IT's how it should be done. To use code for that purpose is a horrible nasty hack.

ror
10 Jun 11 11:50
Joined:
23 Oct 08
| Topic/replies: 3,078 | Blogger: ror's blog
There's a better way than that without using conditional formatting. If you press ctrl+1, then in advanced formatting settings there are some with red negatives.

Or in custom format:


1. Park on the cell , say B5
2. press Ctrl+1 to see the format
3. select Custom
4. select #,##0;[Red]-#,##

This was from the first google result for 'excel red negative' so you should ask yourself what you're doing wrong on the internets not to find it.


thanks for your replys, tried the above before I posted but it does not seem to work.
what I want to do is click on the p/l column and format the whole column at once to highlight the losing trades.
Then look back at those trades to see if I can tighten my edge.

thanks again
GGR

Tighten your what? Could you get any tighter?

morning rasp, you throwing any darts today?

maybe this week you may hit the board with one of them.

50/50 system doing well (send more money), trebled a small bank over 3 months.
going live soon!!

morning rasp, you throwing any darts today?

maybe this week you may hit the board with one of them.

50/50 system doing well (send more money), trebled a small bank over 3 months.
going live soon!!

Morning. Take a look at the darts, son....

You could only dream of stuff like that....

if you are making so much money, why are you still living with yer mam.

don't choke on your porridge goldilocks!!!!

You're a fine one to talk of fairy tales, system boy....