Forum Discussion
Help with conditional formula using color (watch video)
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
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
https://exceljet.net/excel-functions/excel-cell-function#:~:text=The%20Excel%20CELL%20function%20returns%20information%20about%20a,info%20about%20the%20formatting%20used%20in%20the%20cell.
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.
4 Replies
- links are invalid is this spam?
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/cr6QD9VXr2uHere is that sample excel worksheet used in the video.
https://u.pcloud.link/publink/show?code=XZTka6XZldQXXAdDJC7FlsaobNCoq7N2xS6kexcel 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
https://exceljet.net/excel-functions/excel-cell-function#:~:text=The%20Excel%20CELL%20function%20returns%20information%20about%20a,info%20about%20the%20formatting%20used%20in%20the%20cell.
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.
