You cannot use structured references in conditional formatting formulas. You can apply a conditional format that uses regular cell references to a table column and that format will be applied to new table rows. It gets VERY messy when new rows are inserted and deleted in the middle of the table. Use conditional formatting in Access forms and reports. Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel, but many users aren't aware it exists. Did you know that it's possible to apply conditional formatting to fields in a Microsoft Access form or report based on the value in a different field in the same record? For example, you can look. Watch this video to learn how to Highlight data on forms by using conditional formatting. Watch this video to learn how to Use conditional formatting on reports. Open the form or report in Layout view, and select the control where you want to apply the conditional formatting. For information on creating forms see, creating an Access form. How to Implement Conditional Formatting in a Continuous Form in MS Access In this article, we explain the steps for applying conditional formatting to a Continuous Form Conditional formatting as the name suggests is the kind of formatting that can be undertaken only when certain conditions are met.

Microsoft Access Conditional Formatting Tablet
Microsoft Access Conditional Formatting Table In Tableau
Microsoft Access Conditional Formatting Table In Excel

Active5 years, 10 months ago

I have searched through various forums to find an example of a conditional formatting that uses the values for a background color which are stored in a field in the table.

My work uses monthly colors to put items on half off sale,12 months 12 colors, so 1st off useing the ribbon won't work. (Oh yea its MS OFFICE 2010 professional version of Access)

I will be printing barcoded SKUs with department names, price, and then the Month name. The month name will have gray background for November. In December all gray tags are half off.

The problem can be solved in VBA as this example from access-programmers.co.ukshows, but it is hardcoded into the module. I.e.

Books on bipolar disorder. I have the month table like so:

This way the color values are stored dynamicly (in case peach paper or pink ink is a billion times cheaper in the future) but the background property of the textbox of the MonthName has no event builder just a pallet selection (or I would have tried =[monthTable]![MonthColor]).

Microsoft access table conditional formatting

So,

a. Should I use the VBA example and test each case? or

b. Can I use the field value as the uhm value in an expression for me.Textbox. MonthName=[MonthColor]?

I only get about twenty uninterrupted seconds at the computer with Access on it to experiment, between my cashiering, pricing, receiving, and inventorying. So i truly appreciate your previous experience.

Eric

user2978151

user2978151user2978151

1 Answer

Since you had the foresight to put the desired colour values into a table, all you need now is a DLookup(). For example, in the On Format event handler of the report's Detail band we can do

which produces

Gord ThompsonGord Thompson

83.1k16 gold badges110 silver badges247 bronze badges

Not the answer you're looking for? Browse other questions tagged ms-access-2010conditional-formatting or ask your own question.

Active2 years, 1 month ago

I have a table and it is for a test plan I am doing for a project, there is a column at the end of the table where the 2 values in it will be Y (passed the criteria) or N (didn't pass the criteria)

Is there a way in Microsoft Word to change the colour of the text on the row with the value of N at the end, this makes it easier to spot the places where it failed the criteria.

Microsoft Access Conditional Formatting Tablet

I know you can do the find and replace method but I was wondering if there was a way to do this automatically so when the user enters N it changes the whole row to red and when they enter Y it changes it back to normal.

Here is a screenshot of my table:

A point in the right direction to an article I may have missed or a direct answer would be greatly appreciated, thanks.

kieron oates

kieron oateskieron oates

1 Answer

I see four ways you can go from here:

Either you create a VBA Macro which automatically jumps in once you change something in your document and updates the table. This will force you to save the document with the file extension *.docm.
Or you create two styles (of type character) which automatically format the table Cell and it's content as you like. You would need to guide the users how to use those styles by advising them or you could also provide separate buttons within your document to call a macro which would apply those styles. Also here the macro option would force you to save the document with the file extension *.docm.
Another option would be to use a Word document with an OLE Microsoft Excel object. The drawback is the users would need to know how to use this embedded Excel object.
The third way you could go is to use Microsoft Excel and use the inbuilt Conditional Formatting of Excel. If you need the results to be in a Word document you would still be able to copy the table back to Word.

Note:

Microsoft Access Conditional Formatting Table In Tableau

I especially mention the document file extension *.docm because this can cause your document to appear dangerous when you send it by email. Perform a google search to read more about Microsoft Office documents containing macros.

Bruno Bieri

Microsoft Access Conditional Formatting Table In Excel

Bruno Bieri

4,9777 gold badges44 silver badges66 bronze badges

1 Answer

Not the answer you're looking for? Browse other questions tagged ms-access-2010conditional-formatting or ask your own question.

Microsoft Access Conditional Formatting Tablet

1 Answer

Microsoft Access Conditional Formatting Table In Tableau

Microsoft Access Conditional Formatting Table In Excel

Not the answer you're looking for? Browse other questions tagged ms-wordms-officeconditional-formatting or ask your own question.