Hello friends, thanks for your time. Please check the image.
LINE01 BUTTON.jpg
I want assign a specific color to the first line (from the first row) then I create this code using macro record.
But for the yellow color RGB(47, 204, 11) I have different conditions not only "Su<Ma", I want the code can considerate other options like "Su<Mo", "Su<Me", "Su<Ju", etc.Please Login or Register to view this content.
How I can do that... In excel we have =IF(L5="Su<Ma, L5="Su<Mo", ...) but in macro I don't have an idea how it works.
Please if you can teach me, it very useful.
Obviously, if I can work directly in the ActiveSheet and do without using a button it be wonderful.
Thanks so much.
Bookmarks