Conditioning Formating

Vinton Douglas

How do you set condition formating in a column using RAG bubbles for the following conditions:

1. Green bubble should appear if the temperature is 118-130 F
2. Yellow bubble if temperature is <118 F
3. Red bubble if temp is 130 F

Bassam Khalil

Hi @Vinton Douglas 

Hope you are fine, please try the following formula and convert it to column format formula:

=IFERROR(IF(AND([temperature ( F )]@row >= 118, [temperature ( F )]@row <= 130), "Green",
IF([temperature ( F )]@row > 130, "Red", "Yellow")), "")

The following screenshot shows the result:

Vinton Douglas

Hi Bassam,

This is excellent and what I am hoping to achieve. I am however unable to achieve the outcome results of the bubble when I insert the formulla. Are you available for me to share the sheet?

Bassam Khalil

@Vinton Douglas 

yes please share me as an admin and i will fix it for you. the conditional formatting column must be Symbol type ( RGB )

My Email: Bassam.k@mobilproject.it

Bassam Khalil

@Vinton Douglas 

i fix it for you please check, but you need to convert it to column format formula.

Vinton Douglas

Thank you very much Bassam,, you are a genius! The only issue I now discovered is that if the section under temperature remains blank after removing. an input, the bubble remains yellow. Please have a look at the shared sheet.. Grateful if the section under temperature where there is no input, for no yellow bubble to be displayed.

Thanks again.

Bassam Khalil

@Vinton Douglas

Ok I will fix it tomorrow because am out now.

Bassam Khalil

@@Vinton Douglas

I Fix it, please check:

=IFERROR(IF(temperature@row = "", "", IF(AND(temperature@row >= 118, temperature@row <= 130)
,"Green", IF(temperature@row > 130, "Red", "Yellow"))), "")