answersLogoWhite

0

Let's say, for example, that you wanted all positive numbers to be green and all negative numbers to be red. Select all the cells that you want to be color-coded. Go to Conditional Formatting under the Home menu, select Highlight Cells Rules, and the Greater Than. Format Cells greater than 0 with Green Fill with Dark Green Text. To color-code the negative numbers, select the cells, choose Highlight Cells Rules under the Condition Formatting menu, and select less than. Format cells less than 0 with Light Red Fill with Dark Red Text. You can format cells that are equal to 0 using the Equal to option.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Why is it when you multiply two negative integers that it is a positive answer?

Multiplying anything non-zero by a negative number changes the sign. A positive number multiplied by a negative number becomes negative. A negative number multiplied by a negative number becomes positive.


What is the sign of the product of 11 negative integers and 2 positive integers?

The 2 positive integers don't affect the sign. Every time you multiply by a negative number, the sign changes, so you have negative, positive, negative, positive... Since the number of negative numbers is odd, the end result is negative.The 2 positive integers don't affect the sign. Every time you multiply by a negative number, the sign changes, so you have negative, positive, negative, positive... Since the number of negative numbers is odd, the end result is negative.The 2 positive integers don't affect the sign. Every time you multiply by a negative number, the sign changes, so you have negative, positive, negative, positive... Since the number of negative numbers is odd, the end result is negative.The 2 positive integers don't affect the sign. Every time you multiply by a negative number, the sign changes, so you have negative, positive, negative, positive... Since the number of negative numbers is odd, the end result is negative.


What are the rules fr multiplication and divisions of integers?

(positive number) x (positive number) = positive number (positive number)/(positive number) = positive number (positive number) x ( negative number) = negative number (positive number)/( negative number) = negative number (negative number) x (negative number) = positive number (negative number)/(negative number) = positive number


What does a negative number multiplied by a negative number equal to?

A positive number. Positive Number x Positive Number = Positive Number Positive Number x Negative Number = Negative Number Negative Number x Negative Number = Positive Number


Does a positive number times a negative number equal a negative or a positive number?

A negative number. A positive number x a positive number = a positive number A negative number x a negative number = a positive number A positive number x a negative number = a negative Hope this helps :D


How do you work out how to times a positive number by a negative number?

A positive number times a positive number will always get you a positive number A negative number times a negative number will always get you a positive number (same signs will get you a positive number) but A positive number times a negative number will always get you a negative number or A negative number times a positive number will always get you a negative number (different signs will get you a negative number)


When you multiply a negative number by a positive number is the number positive or negative?

The result of multiplying a positive number by a negative number is a negative number.


When you divided a negative number by a positive number witth the answer be positive or negative?

A negative divided by a positive is negative. A negative divided by a negative is positive. A positive divided by a positive is positive. A positive divided by a negative is negative.


What is a negitaive times a positive?

A negative number times a positive number will give you a negative product.A negative number times a positive number will give you a negative product.A negative number times a positive number will give you a negative product.A negative number times a positive number will give you a negative product.


Negative 1000 divided by 100 equals what?

10


A negative plus a positive?

If the negative number is bigger, you get a negative number as an answer. If the positive number is bigger, you get a positive number as an answer.


Is a positive number multiplied by a negative number a positive answer?

No No. Positive number multiplied by a negative number gives a negative number.