Hi there. I’m still sort of new to complicated powershell scripting and this is one I’ve been beating my head against the wall on. I have a script running now that pulls a list of PCs from a CSV file and loops through a list of check. One of the checks hits Active Directory and dumps the result out to Excel (not CSV).
What I would like to do is turn that Excel cell green if it matches the correct OU but then red if its not in the right OU. I dont have to see the full OU in the cell like I do now. If it is easier to just change the cell to read “correct” or “incorrect” that would be fine too.
Anyone have any ideas?