formatting cells depending on other cells

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
 
F

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
 

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.

Ask a Question

Similar Threads

Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
format cells depending on value range 5
Multiple items selected multiple dependancies available 3
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
How To Copy Text To Other Cells 6
Cell text and background colour dependant on result 1
Return a value if a range of cells contain text 2

Top