Underline or Bold or Italic on the basis of formula

[habibian88]

Starting from A1 till A10 I have the following;

9:00:01
9:05:03
9:08:02
9:03:02
9:12:01
9:15:05
9:10:01
9:09:01
10:00:01

These are appearing in this cell on the basis of a formula, is there any way out that those time, which are above 9:10:59 should get Underlined or Bold or Italic.

 

[SydneyGeek]

Use Conditional Formatting.
It's very different in 2007/2010 so you should check the Help for your version of Excel. You can define any format you like for up to 3 conditions (versions up to 2003) or any number of conditions (2007 and higher)

Denis

 

[habibian88]

Great.. Thanks.. I have done it accordingly..