How do i define cells in different colours

[Sheena]

I am using Access Data base and i want to colour different cells with Red
Amber and Green but can only change the background to one colour or alternate
colours. It is to help identify good jobs pending jobs and jobs that have
booked work.

 

[Jerry Whittle]

First off, Access does not have cells like Excel. It has fields and rows (AKA
columns and records).

In a form or report, you can use conditional formating to make field look
different depending on the data.

There isn't condition formatting for tables or queries.