Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
how do i set conditional formating so in the column which show gender i will
have M for male and F for female |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) |