Can anyone help me with an Excel question

Reply Subscribe

Thread Tools

Search this Thread

09 December 2008, 11:58 AM

EddScott

Scooby Regular

Thread Starter

Join Date: Sep 2003

Location: West Wales

Posts: 12,573

Likes: 14

Received 64 Likes on 32 Posts

Can anyone help me with an Excel question

How do I get a minus percentage figure to show up in red like a minus accounting figure does?

Is it using the IF function?

Thanks

Reply Like

09 December 2008, 12:07 PM

HankScorpio

Scooby Regular

Join Date: Feb 2004

Posts: 5,848

Likes: 0

Received 0 Likes on 0 Posts

Format...
Cells...
select Custom...
Enter this in the box

0.00%;[Red]-0.00%

Reply Like

09 December 2008, 01:17 PM

EddScott

Scooby Regular

Thread Starter

Join Date: Sep 2003

Location: West Wales

Posts: 12,573

Likes: 14

Received 64 Likes on 32 Posts

Reply Like

09 December 2008, 04:26 PM

HankScorpio

Scooby Regular

Join Date: Feb 2004

Posts: 5,848

Likes: 0

Received 0 Likes on 0 Posts

You're welcome

Reply Like

09 December 2008, 08:11 PM

HHxx

Scooby Regular

Join Date: Nov 2001

Posts: 2,576

Likes: 0

Received 0 Likes on 0 Posts

Can also be done in "Conditional Formatting..."

Reply Like

Reply Subscribe

Related Topics

Thread

Thread Starter

Forum

Replies

Last Post

2004 (54) Blue JDM Widetrack STi Fresh Import

KAS35RSTI

Subaru

04 November 2021 07:12 PM

BUGEYE PRODRIVE STI BREAKING(rota's/racebox/whiteline/cusco/prodrive styling/6speed+

Mattybr5@MB Developments

Full Cars Breaking For Spares

28 December 2015 11:07 PM

BUGEYE PRODRIVE STI BREAKING(bc br's/rota's/afterburner/6speed/ej207/brembos/prodrive

Mattybr5@MB Developments

Full Cars Breaking For Spares

18 November 2015 07:03 AM

Lateral MD321H Billet turbo

leg200

Subaru Parts

07 October 2015 07:31 AM

New car new problems - alcatek

Brzoza

Engine Management and ECU Remapping

02 October 2015 05:26 PM

Reply Share

First
Prev
1 / 1
Next
Last

Forum Jump