In a nutshell, I have a list of test applicants whose names are in Column A.
If they pass the test (several different columns of scores are needed to know
if they passed) I want their names bolded, if not, their names should remain
in the normal font state.
So column A is the name, column B needs to be 75 or above, column C needs to
be 80 or above, column D needs to be 77 or above, etc. If all of these
criteria are met (ie, the value in the cell is = 75 in B and 80 in C, etc.,
then column A should be bold font.
How would I write code for this? Thanks in advance for your help.

Try conditional formatting ?

Select col A
Click Format Conditional Formatting

Under Condition 1, put it as
Formula is: =AND(B1=75,C1=80,D1=77)
Click Format button Font tab Bold? OK
Click OK at the main dialog

Adapt the formula to suit ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Donna" wrote in message
...
In a nutshell, I have a list of test applicants whose names are in Column
A.
If they pass the test (several different columns of scores are needed to
know
if they passed) I want their names bolded, if not, their names should
remain
in the normal font state.
So column A is the name, column B needs to be 75 or above, column C needs
to
be 80 or above, column D needs to be 77 or above, etc. If all of these
criteria are met (ie, the value in the cell is = 75 in B and 80 in C,
etc.,
then column A should be bold font.
How would I write code for this? Thanks in advance for your help.