Help with if statement with dates

[dhamilton215]

Hey all,

So my situation is that we have an excel layout that has a column H that has dates that the item needs to be calibrated. I was wondering would it be possible to set an IF statement that would change either the box that has the date or a separate box to the side, either red for if it expires 2 months from the current day yellow if 3 months, and green for 4 months and over? Anyone who could help would be much appreciated.

 

[Blade Hunter]

You need to use Conditional Formatting, My use of it has been limited (only once or twice) so rather than me try and explain (and most likely get it wrong) do a quick Google search for "Excel Conditional Formatting" and it will give you what you need.

Cheers

Dan

 

[Teeroy]

You description is fairly consistent with conditional formatting. Have a look at Conditional Formatting to understand how you can use it.

 

[dhamilton215]

Alright thanks. I haven't used this type of formatting before but I'll give it a try, tomorrow.