View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default Conditional Formattting

Sorry, not only am I not an expert but I can't read either !!
Try again: In C1 Conditional Formating enter =$C1="IN" copy across colums
and copy down rows as required.

"Ron@Buy" wrote:

I'm not an expert, but click on cell A1 and in Conditional Formating formula
enter =A1="IN"
Change A1 to the cell reference where you require the formatting.

"kaci" wrote:

Hello all,

I would like to do a conditional formatting in which if value in Column C =
"IN", then change the color of that particular row to yellow.

I tried to create a formula as =C:C="IN", but it doenst work.

Any expert advice?