See ans in previous conditional formatting question.
--
Don Guillett
SalesAid Software

"paul" wrote in message
...
Hi Guys,

I need help with a conditional formatting problem. I
have the following fields in Excel:

id:
first name:
surname:
position:
fte:

and what beside each of them is a cell saying either true
or false.

what I need excel to do automatically, is to change the
listed felds above to a red font if true or leave as if,
If false.

Is there anyway to do this... preferably by Macro...

many thanks,

Paul