Conditional Formatting...

Chrisopia

Registered User.
Local time
Today, 08:00
Joined
Jul 18, 2008
Messages
279
I have a list of names in a form from a query, I would like to colour code the names, for example, Green for current customers, Brown for potential customers and Red for Bad debt customers...

I am sure it is possible, I have seen it done before, but I can't seem to find the guide anywhere any more...
 
Oh and there is a Yes/No field if the person is a customer, and another yes / no field for bad debt customers, relayed from a complex query...
 
If you are using pre 2010 you are limited to 3+1 formatting options, however 2010 has 32 options. Read up on Conditional Formatting
 
Thanks for that... I found the conditional format window... very limited and not very useful... I didn't see any point about updating to 2010 seeing as not much had changed... however I will investigate further into using scripts to format it...

Ill keep you posted.
 

Users who are viewing this thread

Back
Top Bottom