Excel conditional formatting

Hi! Good Day

I have an excel file with values from 0.00 to 0.99 in column A

I would like to get column "A" or "B" to be formatted with colors according to the values in column "A"

<0.85 - GREEN
=0.85 - YELLOW
>0.85 <0.90 - ORANGE
>0.90 <0.95 - VIOLET
>0.95 - RED

Please refer to the attached file

hi,

Find the updated sheet

Punnam

kjxavier ,

Thanks for the reputation , mark the thread solved if that take care of your question

Punnam