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.
CF>Condition1 Cell Value equal to "M"
Format as Red
Add>Condition2 Cell Value equal to "F" format as green
If I have misinterpreted, ignore or post back.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
