PC Review


Reply
Thread Tools Rate Thread

How do i define cells in different colours

 
 
Sheena
Guest
Posts: n/a
 
      5th Oct 2009
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.
 
Reply With Quote
 
 
 
 
Jerry Whittle
Guest
Posts: n/a
 
      5th Oct 2009
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.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font colours in cells. Value increases with increase in font. Microsoft Excel Misc 3 25th Mar 2009 03:22 PM
Colours of cells change Matt Microsoft Excel Misc 0 28th Jan 2009 10:40 AM
can i add colours cells only in excell =?Utf-8?B?a2V2aW4ucXVpcmllQGhvdG1haWwuY28udWs=?= Microsoft Excel Worksheet Functions 1 1st Jul 2007 11:54 PM
Adding cells by colours =?Utf-8?B?d2hhdHp6dXA=?= Microsoft Excel Misc 1 17th Aug 2005 01:02 PM
VB - turning cells specified colours Fraggs Microsoft Excel Programming 7 16th Apr 2004 06:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:02 PM.