Forum Discussion
Excel conditional formula for due dates
Hello, I am a very new to formulas in excel and are trying to set up an excel sheet to help me with work. What I am trying to do is create a formula that will change the fill color of a cell if t...
Justalex123 What you are looking for is Conditional Formatting. The first step is to create a new column next to your RFI Due column that calculates the remaining number of days. The formula to track real-time daily updates would be:
=H2-TODAY()
From there, you select the new column and apply a Conditional Format
From there you can control the control the cell format based on the condition you select:
Rinse & Repeat