How to use GREP to make negative figures in red, INCLUDING past the decimal point?

Forum|Forum|3 years ago
August 29, 2022
2 replies
734 views

Hello one and all! Im currently using a GREP style to change all my negative figures automatically into it's red colored character style, however it will not include the numebers that appear after the deeecimal point. Does anyone have a solution for this please?

Im currently using -\$\d+

Cheers!

How to

This topic has been closed for replies.

Correct answer Peter Spier

I would use -\$?\d+\.?\d*

It should find negative numbers with or without the $ and well as with or without a decimal.

Peter Spier

Correct answer

Community Expert

I would use -\$?\d+\.?\d*

It should find negative numbers with or without the $ and well as with or without a decimal.

J

Jacquie WestAuthor

Inspiring

Oh my gosh, so close! Thanks for that. The only thing I need it to include now is the letter after the number, such as the 'M' to represent the Million. Please see here:

Scott Falkner

Community Expert

Try this expression:

-\d+(\.|)\d+

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded