Get instant live expert help on I need help with excel rgb color
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to add an option to sort by cell color to the following macro. For Each Column On ActiveSheet.UsedRange.Columns Column.Sort Key1:=Column, Order1:=xlAscending, Header:=xlYes, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Next Column Need to add: SortOnCellColor, SortOnValueColor = RGB(255, 199, 206) in the above macro
Solved by E. Y. in 21 mins
Hi, I want to create an EXCEL function, which should fill the background based on RGB parameters on it. The function should looks like this: Function CellBackgroung(Red,Green,Blue) Sample: =CellBackgroung(80,120,40) Thanks
Solved by O. H. in 14 mins
Is there a way to pull the color information from a cell and display in columns marked Red Green Blue and Hex? I have a sheet where the cells are colored. I need to translate them into RGB without having to look the them up individually. In essence I need to pull the information in column A to populate columns C,D,E. I manually populated these columns in the uploaded sheet.
Solved by F. S. in 17 mins
i need to change color on the excel.....
Solved by S. Y. in 28 mins
color drop down bottons do not work in excel
Solved by M. Y. in 13 mins