Search results for query: *

Are you sure they don't have some unusual or incorrectly configured rule setup?

Thank to both of you. I'm stubborn and got both solutions working! Not sure why PHV's gave me troubles are first but revisiting it worked smoothly.

...I.e. be green if the value is from 20% to 40% (going for a heatmap view). I'm pretty sure this is identifying if the value is exactly the criteria * 0.2 rather than greater then the criteria * 0.2. Hopefully that makes sense. I'm going to mess with it a bit and see if I can get the syntax...

Hello all, I'm a pure VBA beginner, working on some conditional formatting for eight conditions. The conditional formatting works fine but I'm recycling some basic internet found code and locking down the location in the spreadsheet I'm testing against is causing me problems. Here's the code...

Thanks, will do!

Hello all, I'm a pure VBA beginner, working on some conditional formatting for eight conditions. The conditional formatting works fine but I'm recycling some basic internet found code and locking down the location in the spreadsheet I'm testing against is causing me problems. Here's the code...

If you have all of the data setup the correct way in sheet 1, why do you need to use formulas to get it onto sheet 2? A better way to ask: What are you changing from sheet 1 to sheet 2?

Good afternoon! I'm getting a generic error message using Impromptu 7.1 that doesn't help me troubleshoot: NCR TDATA.DLL "Continue request submitted but no response to return." The query works fine when I'm filtered for only a few lines of results. I'm looking to remove the filter to pull...

Bah! Anotherhiggins beat me to it! :)

You just need to modify the formula a tad: =SUMIF(D1:D5,"X",E1:E5) Good luck!

It's forth from the bottom (sorry for the double post, there's no edit feature >< )

This website has some cool chart info including what I think you're looking for: http://andypope.info/charts.htm

Sorry, change H to =COUNTIF($C$2:$C$50000,G2) in order to maintain the references!

...Column H: =COUNTIF(C2:C50000,G2) Column I: =LEFT(G2,FIND(" ",G2)-1) Column J: =MID(G2,FIND(" ",G2)+1,100) Column K: =H2 This will take a *long* time to process based on the size of your dataset but it will return the unique list of combinations with a count... some standard sorting will then...

I know you're looking for an Excel solution but this sounds like it would be a snap if you imported the table into access. Just a thought.

It would help to know the formula in A1, does the formula return a blank? If so, =if(A1="","---",1) should work... but if fully depends on what the formula in A1 is.

Check the Excel "zoom" and the screen resolution.

Check the desktop resolutions of both machines as well.

I'd love to hear the exact answer to this myself as I've encountered this problem frequently. I can't speak to the specifics but it seems to be related to the order the programs are opened and how that makes them group with each other. Along the some lines as opening two sessions of Excel vs...

You can also try... =CHOOSE(IF(A2<=87,1,IF(A2<=167,2,3)),"Office 1","Office 2","Office 3")