Conditional Formatting in a table

[Farisha]

Task Name	A	B	C	D
A	21-May-18 <tbody> </tbody>	31-Aug-18 <tbody> </tbody>	13-Jul-18 <tbody> </tbody>	17-Jul-18 <tbody> </tbody>
B	23-May-18 <tbody> </tbody>	31-May-18 <tbody> </tbody>	7-Aug-18 <tbody> </tbody>	24-Aug-18 <tbody> </tbody>
C	20-May-18 <tbody> </tbody>	23-May-18 <tbody> </tbody>	13-May-18 <tbody> </tbody>	18-May-18 <tbody> </tbody>
D	1-Jun-18 <tbody> </tbody>	8-Jul-18 <tbody> </tbody>	31-May-18 <tbody> </tbody>	4-Jun-18 <tbody> </tbody>

<tbody>
</tbody>

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