Conditional Formatting

[Guest]

Hi,

In cell G the permanent number is 63, in cell H the number is 60 and I would
like to have the cell calculate and turn red if less than 20%. How would I
achieve this.

Thanks

 

[David Biddulph]

If you are saying that you want H1 to turn red if it's less than 20% of G1,
then use
Format/ Conditional Formatting/ Cell value is/ less than/ =20%*G1

 

[Guest]

Thank you David that worked, would it be the same for the opposite, if I
wanted to reverse the order?

 

[David Biddulph]

Yes, and if you need more flexibility you can use the "Formula is" option,
rather than the "Cell value is".

 

[Guest]

Great!

Thank you very much, works wonderfully.

Yes, and if you need more flexibility you can use the "Formula is" option,
rather than the "Cell value is".