I have a workbook for all of our police officers employee info. I would like to somehow do a conditional format for the whole workbook where depending on the officer's rank including civilians would be color-coded with a specific highlight and specific text for all of their info across the rows. So like all "Patrol Officers" would have a light blue highlight with a dark blue text color. Then if an employee was either demoted or promoted to a different rank, all their info would change to that rank's highlight and text colors. It takes so long for me to do this across multiple worksheets and multiple rows of cells.
27.5 KB Views: 7