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

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

For just Conditional Formatting with no programming code see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

I don't understand how True/False would be applicable to the
right of each cell.unless you are trying to show that a field is
not filled in. If you wanted to make sure that all of the
fields were filled in you could use something like
Select columns A:E with cell A1 as the activecell

formula is:
=OR(ISBLANK($A1),ISBLANK($B1),ISBLANK($C1),ISBLANK ($D1),ISBLANK($E1))

Then all cells in A:E per row would show a red font if any cell
in columns A:E of the row are filled in.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

Meant for last line to read:
Then all cells in A:E per row would show a red font if any cell
in columns A:E of the row are filled in **but not all cells in
columns A:e of the row**..