Forum Discussion
Km100
Jan 01, 2022Copper Contributor
Change only a part of formula when drag drop in Excel
So I was just doing a HEX to RGB converter in excel, but when I pull it to the other cells, there's a part of the formula that I didn't wan't it to change. Example: =GetRGBFromHex(B2,C1) Bold=don'...
- Jan 01, 2022
Km100 Use $C$1 to make the reference to C1 absolute.
Riny_van_Eekelen
Jan 01, 2022Platinum Contributor
Km100 Use $C$1 to make the reference to C1 absolute.
- Km100Jan 01, 2022Copper ContributorThank you!