TEXT COLOR AUTOMATIC CHANGING

M

Muhammad Saqlain

sir,
when i write in cell yes text color green and no the color is red but i want
the another cells text color change when write yes in cell a1 cells a2:a5
text color change please help
 
F

Frank Kabel

Hi
- select A1:A5
- goto 'Format - Conditional Format'
- choose 'Formula is' and enter the formula
=$A1="Yes"
- chhose your format
 
Top