How do I use Conditional Formatting to change pos No to a Neg No

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a conditional format to change a positive number to a
negative number if a specific condition exists. ie.
=if(C5="Expense"or"Reimbursement", change C7 to negative
Not sure how to finish it. Anyone.
 
Try this:

I'm assuming that C7 will always be a positive number.

=IF(OR(C5={"Expense","Reimbursement"}),-C7,C7)
 
You must log in or register to reply here.

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

Similar Threads

Question about conditional formatting of zeros in Excel 0
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
pos & negative format?? 4
Change Text Colour 2
How to Match a neg with a pos. number 4
Sorting pos. & neg. numbers in a cell 1
Negative Conditional Formatting Excel 2003 2
Can I do a conditional formatting on a cell that is not the same w 4

Back
Top