How to change the text color using formulae?

's Computer Specifications

Hi,

I have some data which contains time values.. I want to mark those cells
with red text, where the time value is more than 4:00:00 Hrs. Please advice
how to do it.

's Computer Specifications

Hi,

You could use conditional formatting:

Format|Conditional format
Cell value
Select Is greater than
enter 04:00:00
Pick a font colour

Mike

"Ganesh Hegde" wrote:

> Hi,
>
> I have some data which contains time values.. I want to mark those cells
> with red text, where the time value is more than 4:00:00 Hrs. Please advice
> how to do it.

's Computer Specifications

Thank you.

"Mike H" wrote:

> Hi,
>
> You could use conditional formatting:
>
> Format|Conditional format
> Cell value
> Select Is greater than
> enter 04:00:00
> Pick a font colour
>
> Mike
>
> "Ganesh Hegde" wrote:
>
> > Hi,
> >
> > I have some data which contains time values.. I want to mark those cells
> > with red text, where the time value is more than 4:00:00 Hrs. Please advice
> > how to do it.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Searching TEXT in formulae, rather than results of formulae	=?Utf-8?B?QW5keUU=?=	Microsoft Excel Worksheet Functions	1	15th Jul 2005 10:57 AM
Bullet Font Color Changes When I Change Text Color--Can I Change it Back?	J. Danniel	Microsoft Powerpoint	2	17th Mar 2005 08:06 PM
Cell color change with the input of color coded text	=?Utf-8?B?bmV3YnkgYmx1ZXM=?=	Microsoft Excel Misc	1	19th Nov 2004 02:49 PM
RE: change notepad background color/text color	Jonathan	Windows XP Customization	1	4th Oct 2003 12:24 AM
change notepad background color/text color	Jonathan	Windows XP Customization	4	3rd Oct 2003 11:18 PM