Скачать или смотреть Add Random Background Color or Fill Color in Excel - Excel Tips and Tricks

Learn how to add random background color or fill color in Excel.

In Excel, there are various ways to add random background or fill colors to cells. One method involves selecting the cells you want to fill, navigating to the "Home" tab, clicking on the "Conditional Formatting" dropdown, and choosing "New Rule." From there, opt for the "Use a formula to determine which cells to format" option, and input a formula like "=RAND() ＞ 0.5" to randomly fill cells with a 50% chance. Alternatively, to dynamically color cells based on another cell's value, employ conditional formatting by selecting the target cells, clicking on "Conditional Formatting" again, and selecting "New Rule." Then, choose the option "Format cells that contain," set the condition based on the value in another cell, and specify the format you desire. This way, Excel will automatically adjust cell colors based on changes in the referenced cell, providing dynamic visual cues.

Here the steps outlining my video.

Random Fill Color Function
1) Right-click the worksheet.
2) View Code
3) Add the VBA script.
4) Ctrl+S

Random Fill Color
1) Highlight cells
2) Place cursor in subroutine.
3) F5


#fypシ #Excel #tips #Microsoft