Forum Discussion
SarahJP1040
Mar 30, 2023Copper Contributor
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...
NikolinoDE
Gold Contributor
SarahJP1040
Mar 31, 2023Copper Contributor
Hi NikolinoDE - I'm on Excel 365 so those colours aren't recognised and the formula won't accept the RGB code?
- NikolinoDEMar 31, 2023Gold Contributor
- FikturFoxMar 31, 2023Brass Contributor
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?