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 ?

"biswajit paik" wrote:

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