how do i set conditional formating so in the column which show gender i will
have M for male and F for female

Conditional Formatting only allows fromatting to highlight the condition.

It cannot show M if you type male in a cell.

If your want the "M" or "F" hightlighted ina cell, CF will do the job.

CFCondition1 Cell Value equal to "M"

Format as Red

AddCondition2 Cell Value equal to "F" format as green

If I have misinterpreted, ignore or post back.


Gord Dibben MS Excel MVP

On Thu, 21 Sep 2006 12:46:57 -0700, paul wrote:

how do i set conditional formating so in the column which show gender i will
have M for male and F for female