I use conditional formatting to highlight a row that may incude 50 or more columns. There may only be 10 fields that have data.
I put a code (S=Scheduled for example) in column A and the entire row is shaded light red using the formula =$A1=”s”
Is there a way that I could just highlight the fields that have data rather than the entire row?
