colorsmicrosoft excelmicrosoft-excel-2013
I have a table comprised of % values where a higher one is something bad whereas a lower one is good.
Using the quick analysis option "Color Scale" I get at a glance which is better or worse but the coloring scheme goes from red to green, red being lower values and green being higher ones.
Is there a way of inverting it? So that lower values go to green and higher go to red?
No, it doesn't seem this is possible with VBA.
But, here's a ridiculous work-around.
Copy your cells from tab1 and paste them into microsoft word
Then copy that from word back to excel. Delete the values. Now you can format paint them to the other tab.
Now, format paint.
Its possible that you are setting the colour properties in the wrong profile.
PowerShell actually has 6 profiles to chose from:
Current User, Current Host - console:
$Home\[My ]Documents\WindowsPowerShell\Profile.ps1
Current User, All Hosts:$Home\[My ]Documents\Profile.ps1
All Users, Current Host - console: $PsHome\Microsoft.PowerShell_profile.ps1
All Users, All Hosts: $PsHome\Profile.ps1
Current user, Current Host - ISE: $Home\[My ]Documents\WindowsPowerShell\Microsoft.PowerShellISE_profile.ps1
All users, Current Host - ISE: $PsHome\Microsoft.PowerShellISE_profile.ps1
Please try and set the profile colouring in the all users, all hosts profile to see if the settings persist. If it does, then try modifying for your various profiles as a user to get the configuration you want.
for more reading on PowerShell profiles (source for this answer) - see https://blogs.technet.microsoft.com/heyscriptingguy/2012/05/21/understanding-the-six-powershell-profiles/
Best Answer
Quick analysis only helps to quickly create a visualisation. After that, you can select the formatted data and use the Conditional formatting dialog to select another color scale.