=myRGB(r,g,b)
Fill cell with RGB colorThis tutorial will show you how to fill a cell or a range using RGB color in Excel to create a gradient scale.exceldashboardschool.comOption ExplicitFunction myRGB(r, g, b) Dim clr As Long, src As Range, sht As String, f, v If IsEmpty(r) Or IsEmpty(g) Or IsEmpty(b) Then clr = vbWhite Else clr = RGB(r, g, b) End If Set src = Application.ThisCel..
2025. 1. 24.
f(x) = MID(text, start_num, num_chars)
f(x) = MID(text, start_num, num_chars) f(x) = FIND(find_text, within_text, [start_num]) Workset1 : Structural Foundations : Foundation Slab : RC_Mat Foundation, FC27_THK1200, F1 : id 208671 1) id 추출 =RIGHT(B2,6) >> 208671 : 오른쪽에서 6자 출력 2) 카테고리 추출 =FIND(":",MID(B2,12,LEN(B2)))-2 >> 22 : 12자 잘려진 문자열에서 ":" 찾은 위치 - 2 >> "Str...ons" 문자길이 22자 =MID(B2,12,FIND(":",MID(B2,12,LEN(B2)))-2) >> Structural Fo..
2021. 4. 8.