Tender Tracker formula help

Hello ElliotDT​, 

Yes, you can do this with conditional formatting. Select the range of cells containing the dates for all part numbers (e.g., D2:AR4). Go to Home → Conditional Formatting → New Rule → Use a formula to determine which cells to format and enter this formula:

=AND(D$1<=$C2,D$1>=TODAY())

Then choose a fill colour and apply. D$1 refers to the top-row date, $C2 refers to the Renewal Date for each part number. This will automatically colour the cells from the start until the renewal date for each row.

Yes, you can use conditional formatting to do this.

Step 1 - highlight the range you want to get highlighted (e.g. F2:AZ4)

Step 2 - select conditional formatting (on the Home ribbon -> conditional formatting -> New Rule...)

Step 3 - select 'Use a formula to ddetermine which cells to format'

Step 4 - in the formula box enter = $C2>=F$1  (note this is based on the upper left cell being F2 and the $ make it so it will always check column C on the same row and compare it to row 1 of the same column)

Step 5 - click format and choose fill color yellow or what ever you choose

click OK