突出显示EXCEL选定范围内最大值 开发工具---VB编辑器---插入模块，输入：Sub HighlightMaxValue() Dim selectedRange As Range Dim maxValue As Double Dim cell As Range Dim hasData As Boolean ' 检查是否已选择范围 If TypeName(Selection) <> "Range" Then MsgBox "请先选择一个数据范围！", vbExclamation Exit Sub End If Set selectedRange = Selection ' 检查范围内是否有数值数据 hasData = False For Each cell In selectedRange If IsNumeric(cell.Value) And cell.Value <> "" Then hasData = True Exit For End If Next cell If Not hasData Then MsgBox "选定的范围内没有找到数值数据！", vbExclamation Exit Sub End If ' 查找最大值 maxValue = Application.WorksheetFunction.Max(selectedRange) ' 清除原有格式 selectedRange.Interior.ColorIndex = xlNone selectedRange.Font.Bold = False ' 突出显示最大值 For Each cell In selectedRange If IsNumeric(cell.Value) And cell.Value = maxValue Then With cell.Interior .Color = RGB(255, 255, 0) ' 黄色背景 .Pattern = xlSolid End With cell.Font.Bold = True cell.Font.Color = RGB(255, 0, 0) ' 红色字体 End If Next cell ' 显示结果信息 MsgBox "已突出显示最大值: " & maxValue, vbInformation End Sub开发工具---宏---找到刚才添加的---选项，添加快捷键

DD系统遭遇Err:1 http://deb.debian.org/debian buster/main amd64 hdparm amd64 9.58+ds-1 404 Not Found 依次运行下面的代码即可解决sed -i 's/deb.debian.org/archive.debian.org/g' /etc/apt/sources.listsed -i 's/http:/http:/g' /etc/apt/sources.listapt updateapt install hdparm ethtooltee /etc/apt/sources.list > /dev/null <<EOF deb http://archive.debian.org/debian buster main deb http://archive.debian.org/debian-security buster/updates main EOFapt updateapt install distro-info-data lsb-release

一行命令激活win10 powershell 复制下面的命令，在ps里面右键irm https://get.activated.win | iex选择1

通过配置Nginx来禁止直接下载网站目录下的.xls文件 server { listen 80; server_name yourdomain.com; # 禁止访问.xls文件 location ~ \.xls$ { deny all; return 403; } # 其他配置 location / { root /var/www/html; index index.html; } }修改完成后检查配置语法nginx -t重新加载配置nginx -s reload

DD系统遭遇curl: (6) Could not resolve host: raw.githubusercontent.com解决方法 今日打算DD系统，结果提示：curl: (6) Could not resolve host: raw.githubusercontent.com遂搜索解决，直接在命令行输入：echo "nameserver 8.8.8.8" | tee /etc/resolv.conf再运行DD命令即可