Forum Discussion
Solved
Complex IF formula using cell colour and cell value
I have a 365 Excel Workbook with several worksheets in. One of the worksheets contains a row of cells 'Other Duties'!B8:AF8 of which may contain numeric value, if a cell contains a numeric value t...
- a sheet formula can NOT use the color. It can be done in VBA (search this forum and you can find examples) but I would recommend you re-think this exercise and how or why certain cells are those colors. For example if those cells are that color using conditional formatting then use the same logic/formula used in the conditional formatting in the sheet formula. If those cells are colored by user then consider having the user enter values in another table or additional columns or rows of that table to convey that information.
a sheet formula can NOT use the color. It can be done in VBA (search this forum and you can find examples) but I would recommend you re-think this exercise and how or why certain cells are those colors. For example if those cells are that color using conditional formatting then use the same logic/formula used in the conditional formatting in the sheet formula. If those cells are colored by user then consider having the user enter values in another table or additional columns or rows of that table to convey that information.
- Thank you for your expertise and answering my question, i will need to find another way to present my requirement within the worksheet
