I have an Excel macro that formats a page for me. I want to add a step in my macro that basically says 'for any cell in column C that says TRUE, change to YES' and 'for any cell in column C that says FALSE, change to NO'.

Can anyone tell me what the macro would be to read any populated cell in column C and make these changes?