Previous Topic Next Topic

More than 3 conditins -conditional formatting

Closed
surfer - Dec 10, 2009 at 02:25 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Dec 11, 2009 at 01:35 PM
Hello,

I have developed a report in access 2007 and I want to format a textbox backcolor based on colors Red, Blue, Green, Yellow and Orange. The control is textbox on report and control source is a field from querry that fetches color status from database.

Please let me know how can i achieve this.
Related:

1 response

Answer 1 / 1
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Dec 11, 2009 at 01:35 PM
have you tried looking at the formatting using icon sets. there is one there for 5 colours.

could you give an example of the data and conditions that you are trying to work with.

unless of course you find the solution in the icons rules.
1

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response