| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlighting fields while in edit mode of formula | Excel Discussion (Misc queries) | |||
| keystrokes for highlighting fields in subtotal | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| highlighting required fields | Excel Worksheet Functions | |||
Linear Mode
