How to Color WPS Spreadsheet Cells from an RGB or Hex Value Without VBA
Question details
The user wants to know whether Excel or WPS Spreadsheets can dynamically fill a cell with a custom color from a hex or RGB value such as #5B8BAA without VBA, and what manual or rule-based alternatives exist.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a hexadecimal or RGB color value and wants to apply or automate that exact fill color in a worksheet without writing VBA.
- Observed behavior
- Worksheet formulas cannot dynamically assign an arbitrary custom fill color from a cell value; manual custom fill and conditional formatting presets are available without VBA, while Office Scripts can automate color changes in Excel for the web.
Open the workbook in WPS Spreadsheets and identify the cells that need the custom fill color. If you are using a hex value such as 5B8BAA, have the hex code ready or convert it to RGB values before opening the color picker.
Manually apply a custom RGB or hex fill color in WPS Spreadsheets
Use this when you need an exact color such as #5B8BAA on one or more cells and no automatic update is required.
WPS Spreadsheets uses a custom color dialog similar to Excel. A hex or RGB value sets a fixed cell fill color; it will not update automatically when a worksheet value changes.
Select the cell or cells you want to recolor in your WPS Spreadsheets worksheet.
Go to the Home tab and click the Fill Color drop-down arrow.
Click More Colors from the drop-down menu.
In the Colors dialog, select the Custom tab, then enter the RGB values converted from your hex code, or enter the hex value if the color field supports it.
Click OK to apply the selected color to the cells, then save the workbook to keep the formatting.
Highlight cells dynamically with Conditional Formatting preset colors
Use this when cells should change color based on rules or values, but exact hex-driven formatting is not required.
Apply Custom RGB or Hex Cell Fill Colors in WPS Spreadsheets Without VBA
WPS Spreadsheets lets you manually set exact cell fill colors from RGB or hex values through the familiar Fill Color dialog, and supports Excel-compatible conditional formatting. No VBA code is required for fixed colors, and .xlsx files open and save seamlessly.
- 1. Select target cells: Open your workbook in WPS Spreadsheets and select the cell or range that needs the custom color.
- 2. Open Fill Color menu: Click the Home tab and select the Fill Color drop-down arrow.
- 3. Open More Colors: Click More Colors in the drop-down menu.
- 4. Enter the RGB or hex value: In the Colors dialog, go to the Custom tab and enter the RGB components for 5B8BAA: 91, 139, 170.
- 5. Apply and save: Click OK to apply the fill, then save the file in .xlsx or WPS format.
Frequently Asked Questions
Can Excel automatically color a cell based on a hex code typed in another cell without VBA?
No, Excel and WPS Spreadsheets do not have a built-in formula that turns a worksheet hex string into an arbitrary cell fill color. You can manually set the color through Fill Color > More Colors > Custom, or use automation such as Office Scripts.
How do I convert a hex value like 5B8BAA to RGB?
Split the hex into three pairs: 5B, 8B, AA. Convert each hexadecimal pair to decimal: 5B=91, 8B=139, AA=170, and enter RGB 91, 139, 170 in the Custom color tab.
Does Conditional Formatting support custom hex colors from a cell value?
Conditional Formatting can apply a chosen fill color when a rule is true, but it does not read a hex code from a cell and use that code as the fill color dynamically.
Can WPS Spreadsheets open Excel files that already contain custom cell colors?
Yes, WPS Spreadsheets opens .xlsx files and preserves existing cell fill colors, fonts, and conditional formatting in most cases.
Is there a formula to change fill color in WPS without VBA?
No worksheet formula can directly change cell fill color. Use manual fill color or set up Conditional Formatting rules to achieve rule-based dynamic highlighting.
