DavidStank
New Member
- Joined
- Jan 5, 2016
- Messages
- 15
A colleague's spreadsheet uses an IF statement that results in numbers 1-11 and fills the cell with that color (see first attached photo). I don't know how the cell is filled from a single number.
My goal is to find a formula to fill a cell with a pattern based on a reference cell such as those in the second photo. Ideally I would like to have an IF formula with the assignment to fill a cell by reference such as IF(someevaluation, cell format matches format pattern of G3 (as shown in second photo). I have searched the forums but haven't found a way to format a cell's fill pattern based on this kind of reference.
My colleague's options allow for only 11 options for filling where I need 16 with an 'order' to them such as Issue, Data, etc. and whether Critical, High, Medium, or Low priority.
Many thanks in advance for any help.
My goal is to find a formula to fill a cell with a pattern based on a reference cell such as those in the second photo. Ideally I would like to have an IF formula with the assignment to fill a cell by reference such as IF(someevaluation, cell format matches format pattern of G3 (as shown in second photo). I have searched the forums but haven't found a way to format a cell's fill pattern based on this kind of reference.
My colleague's options allow for only 11 options for filling where I need 16 with an 'order' to them such as Issue, Data, etc. and whether Critical, High, Medium, or Low priority.
Many thanks in advance for any help.