Forum Discussion
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 - Hi again, thank you!
I think I'm getting close, one last thing, my colour code is identified as #FADACD - When I used this in the formula the sheet is returning #NAME?. I took the # out of the formula but it didn't recognise it that way either?
Hi NikolinoDE - I'm on Excel 365 so those colours aren't recognised and the formula won't accept the RGB code?
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?
