I am looking for a solution for my excel sheet and am not finding any on the internet.
I have the following data for the dropdown list. I'd like my dropdown list to reflect Column B and the color from Column D according to Column C value that corresponds to the cell from Column B.
I seem to not manage to do the conditional formatting because the values in Column B cells sometimes are the same.
I'd like to have a dropdown list based on the values from column B - done through data validation.
Then, i'd like those cells get the colour mentioned in the column D based on the dependent/additional data from column C.
For certain reasons i cannot combine columns, i.e. have "sickness approved" together in one cell and then colour code it according to that (i wish... then it would be so easy *cry)
So, if i choose "course" value from Column B that corresponds to "approved" from Column C, then that cell has to change color to "green", if i choose "100%" or "90%" from column B in the drop down menu, then that cell changes color to "white", if i choose "leave" that corresponds to "pending" then colour "yellow", etc. For the last value - block - when i choose that empty value from the list, then the cell changes to grey color with stripy pattern.
I hope my explanation is not too confusing.
Are the ways to achieve this? Whether with the inbuilt Excel features or Macro code?
I tried to look around Data Validation and Conditional Formatting, but haven't found options that would help me solve this.
Thank you in advance,
Vik
I have the following data for the dropdown list. I'd like my dropdown list to reflect Column B and the color from Column D according to Column C value that corresponds to the cell from Column B.
I seem to not manage to do the conditional formatting because the values in Column B cells sometimes are the same.
I'd like to have a dropdown list based on the values from column B - done through data validation.
Then, i'd like those cells get the colour mentioned in the column D based on the dependent/additional data from column C.
For certain reasons i cannot combine columns, i.e. have "sickness approved" together in one cell and then colour code it according to that (i wish... then it would be so easy *cry)
So, if i choose "course" value from Column B that corresponds to "approved" from Column C, then that cell has to change color to "green", if i choose "100%" or "90%" from column B in the drop down menu, then that cell changes color to "white", if i choose "leave" that corresponds to "pending" then colour "yellow", etc. For the last value - block - when i choose that empty value from the list, then the cell changes to grey color with stripy pattern.
Column A | Column B | Column C | Column D |
Present | 100% | white | |
Present | 90% | white | |
Absent | sickness | approved | green |
Absent | sickness | not approved | red |
Absent | sickness | pending | yellow |
Absent | course | approved | green |
Absent | course | not approved | red |
Absent | course | pending | yellow |
Block | grey colour with stripy pattern |
I hope my explanation is not too confusing.
Are the ways to achieve this? Whether with the inbuilt Excel features or Macro code?
I tried to look around Data Validation and Conditional Formatting, but haven't found options that would help me solve this.
Thank you in advance,
Vik
Last edited by a moderator: