formatting cells depending on other cells

  • Thread starter Thread starter Malte Lindner
  • Start date Start date
M

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
 
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
 
Back
Top