| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color if text is = or not, to text in other column | New Users to Excel | |||
| Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
| Copy text cell & change text color conditionally | Excel Programming | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Linear Mode
