TEXT COLOR AUTOMATIC CHANGING

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
- select A1:A5
- goto 'Format - Conditional Format'
- choose 'Formula is' and enter the formula
=$A1="Yes"
- chhose your format
 
You must log in or register to reply here.

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

Conditional Formatting 3
Change Color of cell 3
How to filter rows data based on background color of individual cells 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Changing the color of a cell based on the color of another cell. 6
Conditional formatting in Excel 2003 2
protect cell format 1
How to add conditional formating on depand on another cell 1

Back
Top