How To Apply conditional formatting within MS Access 2010. You click View - Design View. Click the Total tab and you'll notice some highlighted options above. Click Format and then Conditional Formatting. This where you will create rules. Click the new rule button. Now you will see the conditions with drop-down menus. To apply Conditional Formatting to one field or more than one field, we will need to switch over to the Layout view. Now, select the On Time Status field. Now, go to the Format tab. On that Format tab, you should see a group called Control Formatting and a special button for Conditional Formatting. Let us now click on Conditional Formatting. To apply this particular conditional formatting rule to a date field in a report (the All Tasks report), do the following: Open the report in Design view. Select the date field. In this case, that's the Due Date field. Click the contextual Format tab. Click Conditional Formatting in the Control Formatting group.
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.
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:
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.
Not the answer you're looking for? Browse other questions tagged ms-wordms-officeconditional-formatting or ask your own question.
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.
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]).
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
Microsoft Access Conditional Formatting Tablet
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