Conditional formatting

[colourfullife]

Hi,

Need Help!

Here is the table i have got.

I want to colour Start%, Finish% coloumns which have percentage values. (They are measured)

If the figures are more than 100% and text; infinity, colour them to Green otherwise Red.

Tried to use conditional formatting funtion PIB but couldn't get what i desire.

Is it possible?

Thanks for any help in advanc.

[MFelix · Accepted solution]

Hi @colourfullife ,

On the condittional formatting you need to place the rules condition then just do it with the following setup:

As you can see it's working as you describe.

Regards,

MFelix