Forum Discussion

Copper Contributor

Sep 23, 2019

Solved

excel formula cell colours

Hi, i'm creating a risk register using cell formulas to give the risk rating, is it possible to also use the same formula string to colour the cell based on the risk rating result. The formula I am u...

excel

Excel on Mac

Formulas and Functions

Kodipady
Sep 23, 2019
jp41867 ,
You can use the conditional formatting to create the color scale. your settings will look something like in attached picture.

Kodipady

Iron Contributor

Sep 23, 2019

jp41867 ,

You can use the conditional formatting to create the color scale. your settings will look something like in attached picture.

jp41867
Copper Contributor
Sep 23, 2019
Thanks loads, that works a treat and will save time colour coding risks! - brilliant help and much appreciated with the quick response 🙂