[請問] excel條件格式化 顏色問題 150P
A B C
50
100
61
A列條件格式化 >60顯示綠底色, <60顯示紅字無底色
因為每次都會往上新增插入欄位,我都是複製貼上,然後再KEY新的資料
但有些儲存格會是空白,例如A3,但是儲存格卻會變成綠底色
我希望空白格就顯示原本沒顏色的格子就好
請問要如何修改呢?
謝謝
第一個解答150P答謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 42.72.6.209
※ 文章網址: https://www.ptt.cc/bbs/ask/M.1457446669.A.742.html
※ 編輯: CLucci (42.72.6.209), 03/08/2016 22:18:33
→
03/08 23:55, , 1F
03/08 23:55, 1F
→
03/08 23:56, , 2F
03/08 23:56, 2F
![](https://i.imgur.com/lHcq25C.jpg)
→
03/09 00:06, , 3F
03/09 00:06, 3F
![](https://i.imgur.com/p64uL6T.jpg)
→
03/09 00:16, , 4F
03/09 00:16, 4F
→
03/09 00:57, , 5F
03/09 00:57, 5F
→
03/09 00:58, , 6F
03/09 00:58, 6F
→
03/09 01:25, , 7F
03/09 01:25, 7F
推
03/09 01:31, , 8F
03/09 01:31, 8F
→
03/09 01:32, , 9F
03/09 01:32, 9F
→
03/09 01:33, , 10F
03/09 01:33, 10F
→
03/09 01:35, , 11F
03/09 01:35, 11F
→
03/09 01:36, , 12F
03/09 01:36, 12F
→
03/09 01:37, , 13F
03/09 01:37, 13F
→
03/09 01:39, , 14F
03/09 01:39, 14F
→
03/09 02:31, , 15F
03/09 02:31, 15F
→
03/09 21:29, , 16F
03/09 21:29, 16F
→
03/09 21:32, , 17F
03/09 21:32, 17F
推
03/10 00:14, , 18F
03/10 00:14, 18F