Set Conditional Formatting

Top Tutorials

New Tutorials

Submit

Login

Register

Tutorial Detail

• Total Hits: 4025

• Average Rating :
  

•  

• Total Votes: 36 votes

• Category: MS Excel/General Formatting

• Submitted on: 2008-04-27 00:59:59

• Submitted By: Devesh Khanna

• Set as Favorite

Description:

Open conditional formatting options:

* Highlight the cells you wish to format.
* In the main toolbar go to Format > Conditional Formatting.

Set the conditions:

* In the "Conditional Formatting" dialog box set Condition 1 to:
"Cell Value Is" "greater than" " 7 ".

Set the associated format:

* Press the "Format" button.
* Change the Font style to bold and the color to "red" then press the "OK" button.    More detail...

Rating Detail

Stars	Percentage	Total Vote
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6

Caste Your Vote

Rating	Selection	Guidelines
Poor:		Very disappointing, useless.
Fair:		Below average, disappointing but not useless.
Good:		About average in its class.
Very Good:		Above average for its category.
Excellent:		One of the best Tutorials in its category.

---