Project Status Spreadsheet

[Stevef777]

Hello All,
I am creating a project spreadsheet to track components through the design, ERP scheduling, and manufacturing phases. I have so far been successful in comparing live dates to the shcedule dates and determining the "days" status of the delta between planned and actual for each part which is either a positive or negative number.
I was wondering if it is possible to conditional format the worksheet to enter text "on track" in say column "C" based on a numerical the value from say column "B" (which is either less than or greater than 0)?
Any help greatly appreciated.
Steve

 

[Sergius]

Hello! It would be easier if you provided a piece of data (not real) to understand what's what. As it is, as it should be. Then the answer will be faster.

 

[Fluff]

You could use something like

=IF(B2>0,"On Track","")

in col C.

 

[Stevef777]

You could use something like

=IF(B2>0,"On Track","")

in col C.

Hello Fluff, thank you that works well. How do I combine the two "IF" formula together?
=IF(B2<0,"On Track",""),IF(B2>0,"Delayed","")

 

[Fluff]

How about

=IF(B2<0,"On Track",IF(B2>0,"Delayed",""))

 

[Stevef777]

How about

=IF(B2<0,"On Track",IF(B2>0,"Delayed",""))

Great thank you.

 

[Fluff]

You're welcome & thanks for the feedback.