Forum Discussion

Copper Contributor

Mar 30, 2023

Excel - Add value based on colour

Hi All, I have an excel sheet where I am trying to create a cash flow estimate based on a programme of building works. Column C has the planned week number, Column D has the planned duration...

excel

Formulas and Functions

SarahJP1040

Copper Contributor

Mar 31, 2023

Hi NikolinoDE - I'm on Excel 365 so those colours aren't recognised and the formula won't accept the RGB code?

FikturFox

Brass Contributor

Mar 31, 2023

Hi SarahJP1040

I'm not quite sure what you are trying to achieve here. But why not use your conditions in formatting the cells to peach?