:"Input text automatic color matching guide"-Table skills免费ppt模版下载-道格办公

"Input text automatic color matching guide"

When doing data aggregation work, if there are too many data categories, it will look very messy. Today I will teach you how to use colors to represent data. Take the grade item purchase table below as an example. Now I want to differentiate the data for different grades. First select the A-E data columns, click "Conditional Formatting" under the "Start" menu bar, and select "New Rule". In the pop-up dialog box, select "Use a formula to determine the cells to be formatted" and fill in the formula `=$A1="高一"` under the editing rule description. Then click "Format" to select the "Pattern" fill color. I chose light blue, which represents the input in column A. The cell will turn blue, and click "OK". At this time, go to column A and enter "Higher One", and this row will automatically turn into a light blue mark. Repeat the above operations for other grades. After the settings are completed, enter the corresponding settings in the form and the color matching will begin. The following are related picture and video resources: - Video resources: [Click to watch](https://font2020.oss-cn-beijing.aliyuncs.com/wps/videos/7cef915ce0c5c039f3893e06985e673d-min.mp4) - Picture of grade item purchase list : [Picture 1](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/3592b69993a8f8fe8457be47405e9cd8.png)- Screenshot of operation steps: [Picture 2](https://font2020.oss-cn- beijing.aliyuncs.com/wps/images/8315a22d0e682ef7a8f744515cc197da.png), [Picture 3](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/7b227ee51d4aab67c4c5eae0cf89d185.png), [Picture 4 ]( https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/32dd8123458f69be82867c6faa6a41c5.png)

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-ru-wen-ben-zi-dong-pei-se-zhi-nan.html