color formatting based on 12 conditions
 

Need help
Like to create a user function to color the fill based on a text character in a range (B2:af37)
P = color
F = color
S = color
V and 4 = color 3
W = color 3
C = color 4
M = color 4
T = color
B = color 4
H = color 3
J = color 3
Thanks for your help.

color formatting based on 12 conditions
 

Hi
a user defined function (which is invoked in the worksheet) can't do
this. Reason: A worksheet formula can only return values but not change
formats.

For this you need an event procedure (e.g. using the worksheet_change
event)


--
Regards
Frank Kabel
Frankfurt, Germany

"scire" schrieb im Newsbeitrag
...
Need help.
Like to create a user function to color the fill based on a text
character in a range (B2:af37).
P = color 7
F = color 6
S = color 3
V and 4 = color 37
W = color 39
C = color 45
M = color 43
T = color 4
B = color 48
H = color 38
J = color 36
Thanks for your help.