How to add conditional formating on depand on another cell

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 [email protected]
 
D

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 ?
 
J

Janusz Pawlinka

U¿ytkownik "biswajit paik said:
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 [email protected]
Click to expand...



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.
 
Top