formatting cells depending on other cells

[Malte Lindner]

sorry for the weird topic, but i didn't know the english name for "bedingte
formatierung"...

however, the problem is the following: i'd like to highlight the text in one
cell depending on the information in another cell. e.g. if the value in cell
B2 is "female" the text in A2 should be green coloured and if the value is
"male" it should become blue coloured. how can i do this? i don't get it...

thanks in advance, malte

 

[Frank Kabel]

Hi
the translation is 'conditional format'. Try the following:
- select cell A2
- goto the conditional format dialog
- choose 'Formula' and enter the formula
=$B2="female"
- choose your format

 

[Guest]

hi,
see this site. it contains the information you want
conditional formatting
http://www.contextures.com/xlCondFormat01.html

 

[Malte Lindner]

thanks a lot... the "function" is what didn't come to my mind...