I am writing a vba program that loops through all the rows in an excel spreadsheet. For each row, I need it to check a particular cell and highlight the row in a light blue when it finds a cell that contains a value with all capitals or UPPER CASE.
I need a check to return T or F to tell the program whether or not ALL values in the cell are in CAPs.
Is there a vba function I can use to accomplish this? Thanks