Highlighting certain fields
 

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?

Highlighting certain fields
 

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?

Highlighting certain fields
 

If I want to highlight columns H thru I when the I value is 75:
I select the range (H1:I100) and use for my conditional formatting formula
=$I175
Note the use of a single $
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"KNL" wrote in message
...
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?