highlight function

  • Thread starter Thread starter Casey
  • Start date Start date
C

Casey

Does anyone know how to apply a function so that works for
the following example: combo box containing pass and fail,
user selects fail, goal is to have a range of cells
automatically hilighted.


range applied voltage min max
200mA 190mA 189.3mA 191.3 pass/fail

if fail is chosen from combo box the cells to the left are
highlighted in yellow to draw attention.

Also if anyone knows a way to change the font color for
text in a combo box I am interested in knowing how.

Thanks
 
You could do this with conditional formatting under the format menu.

Set up a cell underneath your combobox (or use data validation with the list
option) to hold the result of the combobox. Then refer to that cell with the
formula.
 
Back
Top