spreadsheet problem

  langer 19:10 18 Oct 2007
Locked

Hi. I'm in the process of creating a timesheet to use at work in which the hours people work are entered. I've just about completed everything but I have one problem. I need my final entry which contains a formula that shows how many hours an employee has worked to appear red if the value is less than 0.I would appreciate any ideas.

  VoG II 19:11 18 Oct 2007

Assuming this is in Excel, take a look at Conditional Formatting click here

  VoG II 19:14 18 Oct 2007

Or use a Custom format such as

#,##0;[Red]-#,##0

I'm assuming that you are not using Time in Excel because Excel won't display negative times (unless you use the 1904 date system).

  langer 19:49 18 Oct 2007

I'm already using the 1904 date system in order to display negative times. How do I use custom format exactly. Do I have to enter the custom format in the cell where my formula appears. Not sure at all.

  VoG II 19:57 18 Oct 2007

Click in the cell that you want to format, Format > Cells. On the Number tab click on Custom then enter your format in the box that says 'Type:'.

You may want to use a different format to the one I posted but the basic syntax is

positive number format; [Red] negative number format

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

11 best portfolio websites for designers and artists

Office for Mac buying guide: Price, Office 2017 rumours & new features

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?