Hello I need a macro to change row color based on "Level" column. Thanks Teri
T Teri New Member Aug 21, 2019 #1 Hello I need a macro to change row color based on "Level" column. Thanks Teri Attachments WBS.1.xlsx 31.5 KB · Views: 8
Kenneth Hobson Active Member Aug 21, 2019 #2 It looks like your conditional formula does it. Why is a macro needed? If needed, change what to what color based on what value of level column?
It looks like your conditional formula does it. Why is a macro needed? If needed, change what to what color based on what value of level column?
V vletm Excel Ninja Aug 21, 2019 #3 Teri Something like this? 'the color-map' is in Help-sheet. Attachments WBS.1.xlsb 35.7 KB · Views: 11
T Teri New Member Aug 21, 2019 #4 vletm said: Teri Something like this? 'the color-map' is Click to expand...
T Teri New Member Aug 21, 2019 #6 Kenneth Hobson said: It looks like your conditional formula does it. Why is a macro needed? If needed, change what to what color based on what value of level column? Click to expand... Thank you dear Hobson.... it was good advice
Kenneth Hobson said: It looks like your conditional formula does it. Why is a macro needed? If needed, change what to what color based on what value of level column? Click to expand... Thank you dear Hobson.... it was good advice