Excel formula

[BillWright]

Hi. I’m trying to create an Excel spreadsheet for vehicle safety inspections and other due dates. Is there a basic formula for the relative cell to change colour from green to amber to red as the due date approaches?

I’ve concluded that my ballet dancing skills are on a par with my knowledge of spreadsheets.
thanks

 

[Mulcher]

Yes it is possible by using Conditional Formatting to create Rules that determine the format of cells based on their values. You can have cell colours tied to cell values. Hope that makes sense – if not, look up Conditional Formatting.

 

[Wegby]

There are many You-Tube videos that can provide guidance on Excel (and other applications). Check them out; you'll learn some new tricks!

 

[squibb34]

XL tutorials ........... https://www.excel-easy.com/data-analysis/conditional-formatting.html

Frankly I'm not sure the system you seek warrants the time needed to get your head around the formatting issue.

Still, the excitement of Xmas is almost upon us, it's cold outside & there is only so much family time anyone can take when sober.

 

[John Armstrong]

I have something that uses the IF function and "Today()" to give a "check" or "-" which does what you're asking in a colour blind way.

That is, (where A71 is the date of expiry etc) =IF((TODAY()-A71)<3,"check","-")

 

[Barnoe]

Something like this?

If your MOT is upto 330 days old the cell will be "OK"
If your MOT is more than 330 days old cell will read "Due"
If your MOT is 365 days old it will read "EXPIRED!

You can then run conditional formatting on that cell using a formula

=B2="EXPIRED!"
set that condition to red

and another on same cell
=B2="Due"
Set that condition to orange or yellow

	A​	B​
1	MOT Date​	Days Since MOT​
2	12/11/2023​	=IF(A1="","",IF(TODAY()-A1<330,"OK",IF(TODAY()-A1>365,"EXPIRED!","Due"))))​

 

[Barnoe]

Apologies that formula should read

=IF(A2="","",IF(TODAY()-A2<330,"OK",IF(TODAY()-A2>365,"EXPIRED!","Due"))))

I used cell reference A1 it should be A2 obviously

 

[BillWright]

Many thanks for all the help.
looking at the formula, I can see why it’s above my limited capabilities.