Conditional Formatting - Currency to Number (possible?)

G

Guest

In conditional formatting of a control on a report, I only see option to Bold, Underline, Change Font Color Etc
I am wanting to change the format from Currency to a Number when a certain criteria is met
It looks like this is possible, but I don't have a selection in the window to do this?
 
M

Marshall Barton

Kelly said:
In conditional formatting of a control on a report, I only see option to Bold, Underline, Change Font Color Etc.
I am wanting to change the format from Currency to a Number when a certain criteria is met.
It looks like this is possible, but I don't have a selection in the window to do this?
Click to expand...


Not using CF. Use code in the section's Format event.

If thecondition Then
Me.thecontrol.Format = "Currency"
Else
Me.thecontrol.Format = "#,##0.00 "
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting on client 11
Excel Conditional Formatting Removal 7
Conditional Formatting 3
Excel Conditional Formatting 1
Conditional formatting - currency? 2
Strange conditional formatting behavior 3
Conditional Formatting Headache 2
Excel conditional formatting with Weeknum 4

Top