Modules & VBA :: Conditional Formatting - Backcolor Determined By Color Value Stored In A Cell

Jul 21, 2015

I would like to know if this is possible using VBA ( or other method)

I want to determine the back color o a cell based on a color value stored in another cell in other word

backcolor of cell A = the value of cell B

So if I change the numbers of cell B (which is color codes) , backcolor of cells A change accordingly and it will have the color specified in cell B.

View Replies


ADVERTISEMENT

General :: Conditional Formatting - Change Backcolor Of Process If Status Field Contains Certain Text

Jan 8, 2014

I have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".

I have tried vba. plced on the after update

if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this

Changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".

I think conditional formatting is the way to go but i think i need an expression to complete this.

View 7 Replies View Related

Reports :: Conditional Formatting From Another Cell

Sep 5, 2014

I wish to use the conditional formatting that if the date required has passed the current date - i wish for everything for that record be turned red when searched or printed.

ive managed to make the Date Reqd turn red but i dont know how i will make the other cells follow the conditional formatting from another cell?

My other Cells i wish to change to red from the Date Reqd are - Customer Code, Site, Plot No, Product

View 14 Replies View Related

Conditional Formatting Custom Colour / Color

Jun 16, 2005

Is it possible to set a custom background color for conditional formatting? Don't particuarly want to do it via code, but I suspect it might be the only way. If coding is required, can someone advise how and where to put it?

You see, I have a form with a custom background colour. In the conditional formatting criteria, all I want to change is the font color for the control, but when the critiera is set it automatically changes the background to white.

Cheers,
Christine

View 8 Replies View Related

Conditional Formatting -- Lock And Custom Color

Aug 3, 2005

Hi,

I have a continuous subform with a checkbox and a textbox. If the checkbox is checked, I would like the textbox to enable. Since using code will enable the textbox for ALL the records, I'm assuming I need to use conditional formatting.

The problem is that I'd like to set the Locked property of the textbox as well. Just disabling the textbox makes the text hard to read -- it's currently white forecolor, blue backcolor and disabling would make the forecolor grey. The conditional formatting dialog looks like it doesn't use the Locked property, so is there another way I can do it?

Along the same lines, I'd like to use a custom color for my formatting (my blue isn't a standard blue color). Is there a way to enter the numerical value for the color, rather than just pick one from the palette?

View 4 Replies View Related

Forms :: Change Color With Conditional Formatting

Oct 18, 2013

I have a subform that is purely to display information (no edits will be made on it). The subform has a special color on it (company color) that I can not deviate from. My problem is the first record in the subform (displayed as a continuous form) gets the focus. The font is white and standard access has a white background. My end goal would be to elimnate the focus for any record in the subform (if it is possible). I know that I could change the color with conditional formatting but the colors in conditional formatting do not match the company color.

View 4 Replies View Related

Forms :: Conditional Formatting Field Color

Apr 16, 2014

I would like to have a conditional formating colour of green if the field contains a value like 10%..If the field has no value and is blank there will not be any background color change

View 1 Replies View Related

Forms :: Conditional Formatting For Choices And Printing In Color

Aug 23, 2013

I have an access form that has a dropdown box list of 10 choices.

For example:

The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.

They choose 5, 6, 7 or 8 Then it need to print in RED.

So forth and so on.

I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.

I do not know how to use VBL or coding.

View 9 Replies View Related

Forms :: Minus Value Conditional Formatting - Color Background

Feb 5, 2014

I would like to have a Positive value with a green Background and a Negative Value with a Pink Background.

View 3 Replies View Related

Forms :: Conditional Color Formatting For Plus And Minus Number

Apr 18, 2014

how to have a different conditional colour formatting for a plus and a minus number

If the field value is a Plus Number
The background colour will be Green

If the field value is a Negative Number
The background colour will be Pink

View 6 Replies View Related

Forms :: Conditional Formatting - Change Back Color Of Fields

Aug 1, 2013

I have a form in datasheet with the fields "Date In" and "Date out" among other.

I want to be able to Change the backcolour of the "Date In" to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting, but now I only want to apply this formatting IF the "Date Out" is empty.

Access 2007.

View 3 Replies View Related

Reports :: Conditional Formatting - Rows To Be Of Specific Color Based On Value In 1 Field

Jul 24, 2014

I have a report that I would like to have the rows be a specific color based on the value in 1 field on the row.

I have attempted to use conditional formatting but it will not work (IE, I can get font color to change, but not field boxes to have color).

The field is labeled [text144] based on the value in the field (1,2, or 3) I would like the field to be a different color.
i.e.
3 = green
2 = yellow
1 = red

View 4 Replies View Related

Forms :: Conditional Formatting Changing Field Color Based On Hours Passed

Jan 7, 2015

I'm having a spot of trouble trying to get conditional formatting to work. I have an overview form which displays current quotes going through the system, the QuoteStartTime field is generated from the Now() command.I Would like if possible to show, 1 hour = Green, 2 hours = Amber and 3+ hours Red.

I've tried variations of
hour([QuoteStart])>1
DateAdd("h",1,[QuoteStartTime])

I've done this before with a date only field before, but working with time is taking too much time.

View 1 Replies View Related

Modules & VBA :: Retrieve Datasheet Cell Color?

Sep 29, 2014

I'm using conditional formatting on a datasheet to change the background colour of a cell. Is is possible to retrieve that colour?

View 6 Replies View Related

Modules & VBA :: Conditional Formatting After Page Break

Jan 13, 2014

Is it possible to do conditional formating after a page break?

I have been given someone elses mess to clean up. It is a massive procedure which runs dozens of queries, then formats the results and pastes them into a word file at given bookmarks

For most tables there is one record for each lake. However there are several where many entries per lake. The logic being applied is that the font colour for the column is made white, then for each first instance of a lake name the font colour for that cell is made black again.

The problem is there are many times were the first row of data on a new page is not the first record for a particular lake making the reader have to flip back to the previous page to double check which lake they are looking at data for.

So what I want to do is leave the existing logic, and just add turning additional cell's (Column 1, after a page break) font colour back to black.

View 3 Replies View Related

Modules & VBA :: Conditional Form Formatting Depending On Field

Jul 2, 2013

I created a form that applies conditional formats depending on a field. It works fine, until you enter data into one of the conditionally formatted fields, then all hell breaks loose. Conditional formats totally go away and the cells go to #error.

View 3 Replies View Related

Modules & VBA :: Conditional Formatting With Like - Colouring Fields Within A Form

Jul 5, 2014

What I am trying to do is create conditional formatting to colour fields within a form.

The conditional formatting option built in allows me to colour based on set values i.e. Value=Design turns green. I need to somehow say if Value contains the word Design turn green. This is because in addition to the word Design there will be a variable description. I tried editing the conditional format created by the wizard to Value="*Design*" but that didn't work.

Now I'm trying to write it in VBA code but am still struggling. Here's what I tried but it doesn't like it:

If InStr([Forms]![Query2]![Activity] Like "*Design")>0 Then
[Forms]![Query2]![Activity].BackColor = vbGreen
End If

View 14 Replies View Related

Modules & VBA :: Conditional Formatting With Files That Update In A Folder

Aug 20, 2013

I have a folder that .csv files which are connected to my database are updating in. Once the .csv that i specify updates I want a color box to turn green. Is there a way to do this? Maybe just use when the linked text file updates?

View 2 Replies View Related

Forms :: Default Formatting Option In Conditional Formatting Dialog?

Aug 1, 2014

Need to confirm whether the Default formatting option in the Conditional formatting Dialog won't work in datasheet view of a form. Please note that all conditional criteria are working fine but not the Default Formatting option - only in the Datasheet view (In Single Form view the default formatting is working fine)

View 11 Replies View Related

Format Cell Color

Oct 19, 2004

This is a very stupid question, I'm sure...
I want to get Access to find a cells that have a certain value and make them a particular colour so that they can easily be seen by database users. I could also make the font a different colour. I've tried getting the builder to do this in the query I run (for the column the fields appear in) but nothing seems to work. How and where do I enter formatting for colour / font colour based on data that is already in the cell... and what do I need to type?

Also would it be faster to get Access to do this before I run a query - so that the formatting is appllied to the whole table or would it be faster to do it during the query process?

Any help would be much appreciated.

View 2 Replies View Related

Queries :: Change Background Color Of A Query Cell If Certain Criteria Met?

Aug 14, 2015

Is it possible to run a query and have the background color of the query field be highlighted if a certain criteria is met?

I'd like to use the expresion builder if possible.

For example if the values in field A and field B do not match, then field C should be a yellow background.

If this is possible, how is it done?

View 1 Replies View Related

Conditional Formatting

Apr 18, 2006

Hi Guys,

I've a question and I hope you can help me out.......
I'm trying to use Conditional Formatting Options on a Text box called "Date". I'd like that this box become Red if its value is between value1 from Text box "Start Date" and value2 from Text box "End Date" or Green otherwise (in this way the color change dynamically every time I change the values of Text Boxes "Start Date " and "End Date"). How can I do that? What I need to type in the Conditional Formatting Windows?

Thanks a lot for you help!!!!

Ciao Ciao

View 1 Replies View Related

Conditional Formatting

Aug 13, 2007

Hello

On my Database I have used Conditional Formattion to change the colour of the qty to highlight when the qty is getting low however its not as good as I would hope as there are different type of definition of quantity (D of Q) e.g. Each (single items such as a screw) and Roll (such as cord and tape)

Conditional formatting doesnt work well because if I have it as less than 10 the qty is in red, its ok for the each items however not the roll as 10 rolls of tape is more than we would need.

I am just wondering if anyone knows what the code would be to change the colour depending on the qty and the D of Q

All i have got so far is:
If me.qty <10 and DofQ = EA then

Now im stuck for the change colour part

Any help would be great

View 13 Replies View Related

Conditional Formatting Help

Sep 2, 2007

Hi Guys,

I'm after an easy way on being able to change the colour of a field once it a certain figure is reached

For instance

Standard field colour for anything 1-99
100+ changes to red

Would any be able to help me out please?

View 2 Replies View Related

Conditional Formatting

Sep 8, 2005

Does anyone know if there is a way in a report to display an entire row in a different color? I'm running a report based on a query and I need specific information to come up in RED. I read about conditional formatting but you can only apply it to a field in a report, but not to an entire row. Let's say I have a group of managers and I need to know the ones that are making more than $50,000 a year. I don't just want the salary to come in RED, I need the entire row (like name, last name, title, date of hire, salary, etc).
Any ideas?

thanks!

View 2 Replies View Related

Conditional Formatting

Mar 13, 2005

I have 2 subforms on a main form. I would like to compare the value in field 1 og subform 1 to field 1 of subform 2. I can't seem to get the conditional foramtting between the 2 subforms to work. Any ideas?

Jim

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved