Conditional Formatting based on change in one cell

In the attached file I have a Worksheet "SUM" that summarizes information for a given employee in cell "B20". What I need is for the corresponding information in Cell Range K25:T55 to be evaluated given the critieria in the Sheet 9(Code) area.

I believe I am on the right track so far. The trigger event is the change to a selction from the drop down list in Cell "B20" to then change the font of the type of leave in any and all of the cells in the K25:T55 range. However, I am stuck at this point and could use some assistance. Additionally, to perfect this code, I would want the previous cell i.e. Activecell.Offset(0,-1) to be colored the same font as the evaluated cell in the next column.

For the purposes of this example, the result of cells Q25 and R25 would be in Blue font and the result of Cells Q26 and R26 would be in green.

The macro would evaluate all cells in this range (I hate to sound redundant).

I would appreciate any assistance.

thanks in advance.



The code I have so far is below:

Please Login or Register  to view this content.