Highlighting certain fields

  • Thread starter Thread starter KNL
  • Start date Start date
K

KNL

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?
 
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
 
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
=$I1>75
Note the use of a single $
best wishes
 
Back
Top