| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionl format a cell to change text colour
Ensure you have real Excel times in your cells. It looks to me like you have
text, not times. Applying a format to text won't help. It's still text. Try entering the times this way: 0:1:39.672 0:1:33.672 Regards, Fred. "PAULANDBEX24" wrote in message ... THANKS BUT IT HAS NOT WORKED. BOTH CELLS ARE FORMATTED IN TIME with 24 hr clock I inputted your formula but nothing has changed This seems to be the formula i used in office 2003 but i am now using office 2007. Any ideas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i format (colour) selective text in a cell using excel2000? | Excel Discussion (Misc queries) | |||
| auto change cell text colour resulting from a condition | Excel Worksheet Functions | |||
| change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
| Conditionl Format | Excel Worksheet Functions | |||
| how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
