在excel中筛选出35岁以下的数据
并让他变红或者是别的特殊的颜色
比如岁数在D列，你选中D列。
在格式-条件格式-条件1里面选择公式。
输入=IF(D5<35,TRUE,FALSE), 然后在格式设置里面字体设置为红色。
本文来源：https://www.2haoxitong.net/k/doc/e692bf6b0b1c59eef8c7b4cd.html
文档为doc格式
![](https://wkrtcs.bdimg.com/rtcs/image?w=620&md5sum=b1d6f3c04107a0a8db2f17664cd64a12&sign=6fd673eb26&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=27&ipr={"t":"img","w":"620","h":"418","dataType":"png","c":"word/media/image1.png","imgOriW":899,"imgOriH":606})
![](https://wkrtcs.bdimg.com/rtcs/image?w=415&md5sum=b1d6f3c04107a0a8db2f17664cd64a12&sign=6fd673eb26&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=27&ipr={"t":"img","w":"415","h":"228","dataType":"png","c":"word/media/image2.png","imgOriW":415,"imgOriH":228})
![](https://wkrtcs.bdimg.com/rtcs/image?w=584&md5sum=b1d6f3c04107a0a8db2f17664cd64a12&sign=6fd673eb26&rtcs_flag=1&rtcs_ver=3.1&l=webapp&bucketNum=27&ipr={"t":"img","w":"584","h":"540","dataType":"png","c":"word/media/image3.png","imgOriW":584,"imgOriH":540})
