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...
Hi NikolinoDE - Thank you for looking at the sheet, if you look back at it, I've amended the duration column to 4 but the formula you have created doesn't apply the value to each of the new weeks added, that is why I'm looking for the formula to read the format of the cell in order to include the value. I'm sorry to be such a pain!
SarahJP1040 Did you figure this out? I completely understand what you are trying to do and I have the exact same task I am trying to achieve. Its not highlighting based on a value, but returning a value based on highlighting.