What is the formula to do a count down in days in a cell in Excel? Can I have the font turn red on day 0?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
4 views
1 Answers
Dr. Md Rushad Rahman
এমবিবিএস(আরপিএমসি)
,
পিজিটি(মেডিসিন)
You can use =DAYS(A1,TODAY()) to make a countdown in days. Replace "A1" with the cell that contains the date you're counting down to. To make the font turn red on day 0, select the cell with the DAYS formula. Go to the Home tab > Conditional Formatting > New Rule. Click "Format only cells that contain." Change "between" to "equal to" in the drop down menu. Enter 0 to the right of "equal to." Click "Format" and change the Font color to red. Click OK on both windows to confirm the change.
4 views
Answered