Change color when a condition is met

A

AJ

I need to change the color of the font in a text box(Permit Number) when a
check box (Complete) has been checked. I have searched the other postings and
saw that most people are using Conditional Formatting. I tried to use this,
but I guess I am not writing the expression correctly. If anyone can help I
would appreciate it.

AJ
 
L

Luiz Cláudio C. V. Rocha [MVP]

Hi AJ,

select Permit Number textbox, click on Format > Conditional Formatting menu,
and try the following expression:

[Your Checkbox]=-1

Choose the color you want.

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
A

AJ

Thanks, I appreciate it...I was using true instead of -1!

AJ

Luiz Cláudio C. V. Rocha said:
Hi AJ,

select Permit Number textbox, click on Format > Conditional Formatting menu,
and try the following expression:

[Your Checkbox]=-1

Choose the color you want.

Luiz Cláudio C. V. Rocha
São Paulo - Brazil


AJ said:
I need to change the color of the font in a text box(Permit Number) when a
check box (Complete) has been checked. I have searched the other postings
and
saw that most people are using Conditional Formatting. I tried to use
this,
but I guess I am not writing the expression correctly. If anyone can help
I
would appreciate it.

AJ
Click to expand...
Click to expand...
 
Top