Forum Discussion
Help with conditional formula using color (watch video)
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.
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
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.
- Thank you very for your insights.