answersLogoWhite

0


Best Answer

Conditional formatting can be used when you want a certain format i.e bold, italic and in red if a number occurs in the cell you set up the condition on.

I.e. in cell AA you set a condition that if the number in it is greater than 100% turn the font bold, red and italic. This will only then occur if the number put in there exceeds 100

Very useful function for bringing automated response to certain criteria

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Conditional formatting mean in spreed sheets?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What does conditional mean in Excel?

Requirements that must be met before the action can take place.E.g Conditional Formatting is where you tell the spreadsheet to format a cell IF it meets the condition set.


What does conditional pacifism mean?

no


What does conditional loan approval mean?

i do no


Is relative address better from absolute address?

what do you mean by better? =a1 =$a1 =$a$1 and =a$1 all give the same result what is affected is what happens when you drag them across or down. also when used in conditional formatting fixed and relative can be important


What do you mean by formatting?

Destroying table


What does formatting toolbar mean?

type


What does conditional verbs mean?

A conditional verb is something like:Should have done thisWould have done thatThat's what I have heard.I think there are no conditional verbs but there are conditional sentences. egIf it rains we will get wet.The conditional clause begins with if and the main clause begins with we.The event in the main clause depends on the condition in the conditional clause.


What is a conditional statement mean in math?

sulema salinas


What does formatting of CD mean?

In simple terms, formatting a CD prepares it for use, so that data can be written on to it.


What do you mean by formatting table?

Destroying table


What does converse statement mean?

Switching the hypothesis and conclusion of a conditional statement.


How do you cite sources on WikiAnswers?

For example, if you were to cite the question: What does apa formatting mean?Cite for reference page:What does apa formatting mean. (n.d.). In Answers.com, The world's leading Q&A site. Retrieved October 23, 2009, fromWhat_does_apa_formatting_meanIn text, after you write your information, cite by ("What does apa formatting mean", n.d.)