is possible: coloring a cell witha formula

[jamiguel77]

hi all, is possible:

i am on C1, if the value of A1 is equal to 50 then coloring the cell A1 with yellow color?

something like this:

=if(A1=50,colorcell(yellow), A1-B1)

thanks

 

[dreid1011]

hi all, is possible:

i am on C1, if the value of A1 is equal to 50 then coloring the cell A1 with yellow color?

something like this:

=if(A1=50,colorcell(yellow), A1-B1)

thanks

Specifically like that, it is not possible. However, you can use conditional formatting to color the cell yellow with a formula like this: =A1=50 and set the format to fill yellow. You cannot, however, do other calculations with conditional formatting to change a value in a cell or show the result of a formula.

 

[jamiguel77]

thanks

https://chandoo.org/wp/2009/09/03/get-cell-comments/

i crate a personal Formula (addin)

thanks