Conditional formating based on dates in other cells

[Paul D]

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

If cell C3 changes to another date E.g. 08/02/2018, I wish to change the colour of cell H3 to be orange


​

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[TD]F1[/TD]
[TD]H1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

01/01/2018​

<strike></strike>[/TD]
[TD]

05/02/2018​

[/TD]
[TD]

08/02/2018​

<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

I am not sure that your your question is clear.

Conditional Formatting has no problems formatting based on values in other cells (that is what you would use the Formula option for).
What it cannot do is format based on what a value was previously. It has no memory of that. It can only format based what is currently on your sheet. If you need to remember previous values, you are going to need to store those values somewhere else on your sheet or use VBA.

If you just wanted to Conditional Format B1 if it is not the same as A1, you can simply applying this CF formula to cell B1:
<>A1
And, likewise, you can do the same for C1.