So my code looks like this. My question is I’m trying to find a way to add color highlights to certain cells. So for example in the Test-MemoryUsage function the script will produce information about the server printing out the Total Size and the Percent Free. I would like to able to add a style where if the Percent free is less than a number then it will highlight more so red and if it is in good standing then it will highlight green.
function Get-DataSheet{ [CmdletBinding()] param ( ) Begin{} Process{ $frag5 = Test-MemoryUsage | convertto-html -Fragment -PreContent 'Memory Usage
' | Out-String $head = @' <style> body { background-color:#dddddd; font-family:Tahoma; font-size:12pt; } td, th { border:1px solid black; border-collapse:collapse; } th { color:white; background-color:black; } table, tr, td, th { padding: 2px; margin: 0px } table { margin-left:50px; } </style> '@ convertto-html -head $head -PostContent $frag1,$frag2,$frag3,$frag4,$frag5,$frag6,$frag7,$frag8,$frag9 -PreContent 'Data Collection Sheet
' | out-file C:\Data.html Invoke-Item "C:\Data.html" #Open the document. } End{} }