Help with Conditional Formating

[ONWUZUAM]

I computed a conditional formula on my spreadsheet with the condition that all values less than 4weeks should appear with a red font.Surprisingly,the values,which are the product of an earlier calculation,are not conforming to my conditional formula.
How do I get the values obtained from the product of an earlier computation to conform to my conditional formula?
An urgent response would be very much appreciated.
Thank you.

An Example of the file can be found on the MRP sheet in the URL below;
https://www.dropbox.com/s/48xqib4cld...le%29.xls?dl=0

[Glenn Kennedy]

Pleae attach a sample sheet, so that we can see where the cells are that you wish to format and rthe format of the data that's currently there.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic