Forum

Notifications
Clear all

[Solved] Filter between Positive & Nagative numbers

3 Posts
2 Users
0 Reactions
278 Views
(@benjamip)
Posts: 89
Estimable Member
Topic starter
 

Hi,

Is there anyway to filter the 3 Variance columns on attached so you can select either a + sign or - sign rather than Less than or Greater than and then adding 0.

Thanks

Paul

 
Posted : 20/12/2024 6:30 am
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

I notice that you have applied conditional formatting to color negative variances red and white for cells that equal zero. The latter you don't really need. Rather adding buttons to your sheet with VBA code behind it, why not just filter by cell color?

Press the filter button on a variance column, then hover over the 'Filter by color' option and select either the white (not formatted) or the red (negatives) box. That's just two clicks and no need for VBA, even if that would save you one click.

 
Posted : 20/12/2024 8:20 am
(@benjamip)
Posts: 89
Estimable Member
Topic starter
 

Thanks Riny, I thought that was the case, just wanted confirmation

 
Posted : 21/12/2024 8:29 am
Share: