<div>
Try this for the yellow cells<br />
<br />
=OR(C1=TODAY(),C1&gt;TODAY()-<wbr />5)
</div>


Try this for the yellow cells

=OR(C1=TODAY(),C1>TODAY()-5)

<div>
Change =AND(H2&lt;&gt;&quot;&quot;,TODAY()&gt;=H2+5)<wbr /> to =AND(H2&lt;&gt;&quot;&quot;,TODAY()&gt;=H2-5)<wbr /> - and worked perfect; thanks!
</div>


Change =AND(H2<>"",TODAY()>=H2+5) to =AND(H2<>"",TODAY()>=H2-5) - and worked perfect; thanks!

<div>
You're welcome. Glad it worked after you tweaked it. :)
</div>


You're welcome. Glad it worked after you tweaked it. :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am looking to set up a conditional format which sets the background of cells in column H to yellow if the date is within the next 5 days (or today) and red if the date has past?<br />
<br />
I cannot work out the formula to use - would it be something similar to H:H&lt;=[Today]-5 for amber for example?
</div>
</div>


Hi,

I am looking to set up a conditional format which sets the background of cells in column H to yellow if the date is within the next 5 days (or today) and red if the date has past?

I cannot work out the formula to use - would it be something similar to H:H<=[Today]-5 for amber for example?

Conditional Formatting - Date Based

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.