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