Oct 09 2021 10:15 AM
Hello.
I'm in need of assistance with a conditional formula using colors please.
Here is a brief video showing what I'm wanting to do.
[url]https://screencast-o-matic.com/watch/cr6QD9VXr2u[/url]
Here is that sample excel worksheet used in the video.
[url]https://u.pcloud.link/publink/show?code=XZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6k[/url]
I'd really appreciate if you could help me with this.
Thank you!
Ron
Oct 09 2021 05:32 PM
Oct 09 2021 05:35 PM
No sir, this is not spam.
Here are those links again.
Here is a brief video showing what I'm wanting to do.
https://screencast-o-matic.com/watch/cr6QD9VXr2u
Here is that sample excel worksheet used in the video.
https://u.pcloud.link/publink/show?code=XZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6k
Oct 09 2021 05:48 PM - edited Oct 09 2021 06:01 PM
Solution
excel cannot return a color value using formulas other than conditional formulas.
i.e If this cell is grey then put grey here. It can only do if this value in this cell is greater than x then color it grey (it has to be true, but there is no formula in excel that can evaluate color except text color and only red to indicate if the number is negative or not.
see: CELL() function
How to use the Excel CELL function | Exceljet
That is the only formula function that can evaluate text color to indicate if a number is positive or negative.
What you want can only be done in vba macro
tag your post with vba.
Oct 10 2021 02:40 AM
Oct 09 2021 05:48 PM - edited Oct 09 2021 06:01 PM
Solution
excel cannot return a color value using formulas other than conditional formulas.
i.e If this cell is grey then put grey here. It can only do if this value in this cell is greater than x then color it grey (it has to be true, but there is no formula in excel that can evaluate color except text color and only red to indicate if the number is negative or not.
see: CELL() function
How to use the Excel CELL function | Exceljet
That is the only formula function that can evaluate text color to indicate if a number is positive or negative.
What you want can only be done in vba macro
tag your post with vba.