[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

[dennis]

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

[Janusz Pawlinka]

U¿ytkownik "biswajit paik" napisa³
w wiadomo¶ci ...
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



Go to cell C2 and write formula
= if(a2="Computer"; "Yes", "")

and then use "Format-Conditional Formating",
choose from listboxes 'Value Is' and 'equals',
write ="Yes",
press Format button and choose desired cell format.

I don't know how to do this in one step without a macro.
--
==============================
Janusz Pawlinka