Filter by conditional format - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Filter by conditional format

Kevin Whitthread

3 years ago

Hi, is it possible to filter a continuous form by a colour that has been generated from a conditional format?
I'll attach a screenshot.

I need to filter any rows that have a red number, as these do not match the record in the next box.

	Kevin Whitthread OP @Reply 3 years ago

	Adam Schwanz @Reply 3 years ago
You don't need to filter by conditional format, just filter by whatever is setting the conditional format. If qty is <5 makes it red, you don't have to filter by red, you just filter by qty is <5.

	Kevin Whitthread OP @Reply 3 years ago
The numbers will be random, though; it was <5 on that result but can be any number that does not match. This is why I need to filter by red if possible. Thanks

	David Burns @Reply 3 years ago
The numbers in the cell/field may be random but presumably your conditional formatting is fixed?

	Adam Schwanz @Reply 3 years ago
Yes, that was just an example. You have something in the conditional formatting that turns them red right? Whatever that is, filter by that.

	Kevin Whitthread OP @Reply 3 years ago
So, the conditional formula I'm using is [GBP]<>[LowestPrice] How would I use that to filter? Thanks guys

	Adam Schwanz @Reply 3 years ago
`Me.Filter="GBP<>LowestPrice" Me.FilterOn=True`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View