How to add conditional formating on depand on another cell

  • Thread starter Thread starter biswajit paik
  • Start date Start date
B

biswajit paik

Hi
I want to change the cell color & text on depand on another cell. Like
=if(a2="Computer",c2="red")

if a2 is computer then c2 whould be red color & text would be Yes.

Hi pls reply me to my id (e-mail address removed)
 
Is there any good reason you need an extra column to display Yes (meaning Yes
there is Computer in the other column) and then Make it Red instead of
checking your original column and making that Red if it displays computer ?
 
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
Conditional Formating on Several Cells 6
conditional formatting in excel 2007 1
Excel VBA 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Questions on using conditional formatting 2
Conditional Formatting dependent on whether cell is populated. 3
Conditional Formatting Applying Rule to Entire Column 2

Back
Top