Hi,

Select (say) A1 - a10 and then
Format
Conditional format
Formula is
=$A$1<75
Pick a colour.
All the cells you had selected will now highlight if A1 <75

Mike

"KNL" wrote:

I have figured out how to highlight a certain row if the score is less than a
75. However, i would also like to include the several fields next to the
highlighted field. anyone have any suggestions?