Change the color of a row in a form if criteria is met

Mac1206

Board Regular
Joined
Jun 3, 2016
Messages
172
Can anyone tell me how I can change the color of row data in my form if it meets this criteria and how would I create the query if it already has a select statement that populates the form...

* Distribution Type: In-Service Withdrawal
* Disbursement Amount: $50,000.00 or more
* Disbursement Method: ACH Transfer
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Mac1206

Board Regular
Joined
Jun 3, 2016
Messages
172
You could apply the same expression to all controls in the row using conditional formatting ?
Or use Crystal's method.

https://www.youtube.com/watch?v=2ArtsDJrK7k

So, I can apply all 3 criteria's within the expression in conditional formatting and if so, how would I write the expression in order to meet the 3 criteria's:


If any row meets this criteria:
* Distribution Type: In-Service Withdrawal
* Disbursement Amount: $50,000.00 or more
* Disbursement Method: ACH Transfer
Then highlight those specific rows....
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
779
It depends on how many controls you have to whether you do it individually or use Crystal's method.? Up to 5 I'd probably do them individually, any more I'd put in the extra control and do it Crystal's way. The expression would be the same either way?

You build the expression just the same as if you did it in VBA but without the If and with []

[Amount] > 50000 AND .......
 

Watch MrExcel Video

Forum statistics

Threads
1,096,444
Messages
5,450,482
Members
405,613
Latest member
Arpit

This Week's Hot Topics

Top