I need to make a field look different based on a condition.

What I have done is I have a default value field that puts a U for updated in a certain field so I import the data from excel then when people add new data my U gets put in the field.

I think I need a macro that checks the field for the U and if it finds it I want to make another field grey.

I have used the conditional button and it is great but how can I make another field look different based on the condition.

I probably just need someone to teach me to use the conditional button.

Thanks,
Tina

You still use Conditional Formatting, but use Expression Is. An expression like:

[FieldName] = "U"

You still use Conditional Formatting, but use Expression Is. An expression like:

[FieldName] = "U"



I do not understand what you are saying. Would the above go in a query?

I have only used the condition button and it looks like it only works on one field.

Thank You,
Tina

You can set a condition based on the value in another control (often loosely called "fields") in a form or report.

One of the choices in Conditional Formatting is "Expression Is". Set the formatting in [controlname1] to be based on value of another control with:
Expression Is | [controlname2] = "U"

The values of multiple controls can be used in the logic through OR and AND operators.

You can set a condition based on the value in another control (often loosely called "fields") in a form or report.

One of the choices in Conditional Formatting is "Expression Is". Set the formatting in [controlname1] to be based on value of another control with:
Expression Is | [controlname2] = "U"

The values of multiple controls can be used in the logic through OR and AND operators.


So I found what you are talking about.
I changed the condition 1 to Expression is
Then I get lost

This is my row
ID, full_name, Dept, Position, location

When the location field contains "ws" I want

ID, full_name, Dept, Position, location to all be pink

so would I write
Expression is

In the conditional format for ID etc, type the expression: [location] = "ws" and choose pink for the background or text as required.