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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Sheena" wrote:
> 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.
|