Debit/credit amount Slection How?


G

Guest

I have date with Debit and credits amount in selected range. So I want to
high light all credit “-“ amount (not one by one, with one stroke).

Exp.

Credit/Debit
-1502
1788
223
-4250
As above example I want to high light all credit amounts. With conditional
formate or any other option.
 
Ad

Advertisements

S

Scott

There are many ways... here are two:

1) Choose the cells you want to have color. Choose Format -> Cells.
Choose the Number tab. Choose Number from the list. Choose one of the
formats that is in Red. (These formats make negative numbers red, and
leave positive numbers black.) Hit OK.

2) Choose the cells you want to have color. Choose Format ->
Conditional Formatting... Where you see the word "Between" change to
"Less than". In the box beside it, enter 0. Then choose Format...
choose the Pattern tab and choose a colour (say Red). Hit Ok twice.

For more help on Conditional formatting, see Debra Dalgleish's site:
http://www.contextures.com/tiptech.html and scroll down to the C
section and you'll see several links for Conditional Formatting which
take you through the steps.

Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top