Conditional Formatting Questions

[gheyman]

Can you do an IIf statement where if another field is Blank then make the field with the conditional formats text a color?

 

[Russell Hauf]

No and Yes. Not with IIF, but you can do what you want.

Select the cell you want to format, go to Conditional Formatting and base it off of another cell... =(C2="")

(replace C2 with the cell you are checking)

 

[Joe4]

Are you asking whether or not you can Conditionally Format one field based on whether another field is blank?
Are you doing this is a Form or Report?

 

[Joe4]

No and Yes. Not with IIF, but you can do what you want.

Select the cell you want to format, go to Conditional Formatting and base it off of another cell... =(C2="")

(replace C2 with the cell you are checking)

Russell,
I think you may have missed that this question is in the Microsoft Access forum, not the Excel Questions forum!
(though Conditional Formatting is somewhat similar)

 

[gheyman]

In a form. The user needs make a selection in a Listbox. I created an unbound field on the form for the "title" to the List box. If they have not made a selection in the list box I want the "Title" to be in Red and once they have made a selection I want the title to go to Grey - its formatted color.

 

[Joe4]

Assuming this unbound "Title" field is a TextBox, you can use Conditional Formatting like this on it:

Expression is: [[I]ListBoxFieldName[/I]] is Null

and then choose your red formatting option.

 

[gheyman]

One more question, on this. What if I wanted to do an "AND" expression? If two fields are Null? is that possible?

 

[gheyman]

What would you use for is Not null?

[ListBoxFieldName] is not Null Or
[ListBoxFieldName] not Null

 

[Joe4]

One more question, on this. What if I wanted to do an "AND" expression? If two fields are Null? is that possible?

Expression is: ([[I]Field1[/I]] is Null) And ([[I]Field2[/I][FONT=Verdana]] is Null)[/FONT]

 

[Russell Hauf]

Russell,
I think you may have missed that this question is in the Microsoft Access forum, not the Excel Questions forum!
(though Conditional Formatting is somewhat similar)

I sure did! Sorry, was very early for me.