Excel 2007 Conditional Formatting -rows based on value in a cell

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?