I am trying to add conditional formatting that turns yellow after 48 hours from the date in the cell, turns orange after 72 hours from the date in the cell, and red after 96 hours after the date in the cell.
All of the hours you are express can be simplified as days. (2 days, 3 days, 4 days ). You want a condition per color you are using.
Assuming you are doing this on a desktop: If you select the range you want to apply the formatting. Take note of the top-left-most cell of the range & write it down. Right click on the range you selected and select "conditional formatting." Then select "Add new rule." In the drop down menu labled "Format cells if..." select "Custom formula is." Then in The input-box below type out your yellow formula. ( Repeat all of the steps for Orange, & Red ).
Below I listed the Yellow, orange, & red formulas I used assuming your dates are in column A Ranges A2:A1000
Remember when I asked you to take note of the top-left-most cell? If you want to adapt the formula I used in the list above on the Range you are applying your conditional-formatting to, You need to change "A2" into the top-left-most-cell you wrote down.