ExcelBanter - How to change the text color using formulae?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to change the text color using formulae? (https://www.excelbanter.com/excel-programming/413642-how-change-text-color-using-formulae.html)

Ganesh Hegde

How to change the text color using formulae?

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.

Mike H

How to change the text color using formulae?

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.

Ganesh Hegde[_2_]

How to change the text color using formulae?

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.

All times are GMT +1. The time now is 03:25 AM.