Hi All,

I've made a spreadsheet which calculates a VALUE. What I want to do (if it's possible) is to compare that value to another one and display a message depending on whether it is more or less than the second value (preferably in a colour).

Can this be done and could some kind soul please TELL me how??

Many Thanks Use IF function.

For example, =IF(B1>A1,"More","Less")

In the example above, if you want to display "More" and "Less" in different colour, I think that has to be done by using Macro, but unfortunately I never learn to use Macro.Conditional Formatting will do what you want. You'll find Conditional Formatting under the Format menu. Let's use the formula provided in the other post as a basis for discussion; it was =IF(B1>A1,"More","Less"). Let's assume it's in CELL C1.

Select C1. Click on Format, then Conditional Formatting. In the box to the left of Condition 1, click on the drop down arrow and select "equal to". Then, in the next box to the right, enter "More" or "Less". Then, click on the Format button and set the format, i.e. color, etc., for it. This takes care of one condition, either "More" or "Less".

Now, click on the Add button at the bottom of the Conditional Formatting panel and GO through the same procedure for whichever ("More" or "Less") was not dealt with in the first step; this is Condition 2. Now, the answer will be displayed in different colors, depending on what it is.

Soybean, thanks for your answer,
I learned that.
Will try it out.Glad to hear somebody benefited from it. wonderdunder seems to have gotten up and left the PARTY without saying goodbye.He will be known as a Hit and Run Poster.