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

Mac1206

Board Regular
Joined
Jun 3, 2016
Messages
170
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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Mac1206

Board Regular
Joined
Jun 3, 2016
Messages
170
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
777
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,095,693
Messages
5,445,989
Members
405,376
Latest member
Bluedoor01

This Week's Hot Topics

Top