Is it possible to use conditional formatting to format a cell based on a date
For example
Cell A3 = 01/01/2018 - I require cell H3 to be red
If cell B3 changes to another date E.g. 05/02/2018, I wish to change the colour of cell H3 to be green
<tbody>
</tbody>
For example
Cell A3 = 01/01/2018 - I require cell H3 to be red
If cell B3 changes to another date E.g. 05/02/2018, I wish to change the colour of cell H3 to be green
If cell C3 changes to another date E.g. 08/02/2018, I wish to change the colour of cell H3 to be orange
A1 | B1 | C1 | D1 | E1 | F1 | H1 | |
01/01/2018 <strike></strike> | 05/02/2018 | 08/02/2018 <strike></strike> | <strike></strike> |
<tbody>
</tbody>