How to Change color of Text in Cell base on =IF function

Hi, wanna ask if anyone know how to change Text color from Cell base on data from cell.
Like this =IF(Q1 <= 30, “Change Text from Q2 to green”, “Change Text from Q2 to red”).

Hey aiulian7,

You can use the BAR() function.

Example:

=BAR(1,1,IF(Q1<=30,"green","red"))

BAR() allows you to fill a cell with a color, while also changing the amount of the cell to be filled and the fill direction. :slight_smile:

Is this what you were looking for?

Thank you very much.
And one more question, can I change Text color from a cell, base on IF function, not just color the cell ? I have a cell that store temp data, for example if the temp is 30 degree i want to make that text green, if it’s below 30 to make text red.

Hi :slight_smile:

It is not possible to dynamically change the font color of cells.
But it is possible to change the font color of shapes.

You can add shapes to your Streamsheet and reference the shape properties to the grid. This way you could add the IF logic to a cell and reference it to the shape setting of your choice.