Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help to change a cell color based on conditions | Excel Worksheet Functions | |||
Conditional Formatting based on 2 conditions | Excel Discussion (Misc queries) | |||
How to set color for text based on conditions? | Excel Discussion (Misc queries) | |||
Formatting based on text color | Excel Worksheet Functions | |||
Formatting Cells - color based | Excel Worksheet Functions |