Can anyone help me with an Excel question

Reply Subscribe

Thread Tools

Search this Thread

Dec 9, 2008 | 11:58 AM

EddScott

Thread Starter

Scooby Regular

Joined: Sep 2003

Posts: 12,575

Likes: 65

From: West Wales

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

Dec 9, 2008 | 12:07 PM

HankScorpio

Scooby Regular

Joined: Feb 2004

Posts: 5,848

Likes: 0

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

0.00%;[Red]-0.00%

Dec 9, 2008 | 01:17 PM

EddScott

Thread Starter

Scooby Regular

Joined: Sep 2003

Posts: 12,575

Likes: 65

From: West Wales

Dec 9, 2008 | 04:26 PM

HankScorpio

Scooby Regular

Joined: Feb 2004

Posts: 5,848

Likes: 0

You're welcome

Dec 9, 2008 | 08:11 PM

HHxx

Scooby Regular

Joined: Nov 2001

Posts: 2,576

Likes: 0

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

Reply Subscribe

Related Topics

Thread

Thread Starter

Forum

Replies

Last Post

2004 (54) Blue JDM Widetrack STi Fresh Import

KAS35RSTI

Subaru

Nov 4, 2021 07:12 PM

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

Mattybr5@MB Developments

Full Cars Breaking For Spares

Dec 28, 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

Nov 18, 2015 07:03 AM

Lateral MD321H Billet turbo

leg200

Subaru Parts

Oct 7, 2015 07:31 AM

New car new problems - alcatek

Brzoza

Engine Management and ECU Remapping

Oct 2, 2015 05:26 PM

Reply Share

First
Prev
1 / 1
Next
Last

Forum Jump