Conditional Formatting in a table

[Farisha]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Task Name [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]21-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]31-Aug-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]13-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]17-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]23-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]31-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]7-Aug-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD]24-Aug-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]20-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]23-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]13-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]18-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]1-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]8-Jul-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]31-May-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl37027, width: 71"]4-Jun-18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Hello Friends,

I have a above table and I want to assign a conditional formatting in Column C and D. If the Date in Column C is behind the Date is column A . The Value is column C turn Red. and if it is ahead it turn green. Same thing with Column D and B. I need it for all rows of Column C and D. Please advise. Thanks

Farisha

 

[Joe4]

In Access, Conditional Formatting can be applied to a Form or Report, not directly to the Table.
So, if you create a Form or Report of your Table, you can do it.
See: https://support.office.com/en-us/ar...rmatting-6ba9e9fa-4347-4183-b335-44e43b05e22f