Hi guys,
Again I found another very helpful bit while trying to update my report.
We had a sheet for staff leave, and I needed more than 3 options for conditional formatting, so I found some VB code and modified it as below.
This gave me multipul options that did multipul colors. When I type the letter the cell turns the corresponding color;
W = Yellow
S = Green
SN = Sky Blue
B = Purple
P = Light purple
A = Dark Yellow
BR = Grey
J = Dark Orange
V = Light blue
-> Right click on worksheet and choose 'view code' - past the below anad modify cell ref's as appropriate
Yay - works a treat
Bookmarks