mungkin masalahnya ada di sel yang agank abzolutkan di conditional formatting agank tulis =$C$1 (harusnya $C1) karena yang di nili sel c1 melulu... zemoga membantu. salam R125 beriku za lampirkan filenya. tq On 7/30/11, [email protected] <[email protected]> wrote: > Dear Riska, > Conditional Formatting kan bisa tergantung dari rumus/ formula atau value. > > Kalau maunya berwarna merah jika diatas 2, > bukankah bisa dengan conditional formatting if value greater than 2, Pattern > merah? > > Salam > Agung W > > ________________________________ > From: [email protected] [mailto:[email protected]] > On Behalf Of Riska Wahyu Nirmalasari > Sent: Saturday, July 30, 2011 2:51 PM > To: [email protected] > Subject: [belajar-excel] Conditional Formatting > > > > Dear All, > Mau tanya2 lagi. Conditional Formatting apakah tidak berfungsi jika pada > suatu sheet ada rumusnya? > Contoh berikut; > > > Terimakasih bantuannya. > > Regards, > > Riska Wahyu N. > > Ce message x000E9;lectronique et tous les fichiers attachx000E9;s qu'il > contient sont confidentiels et destinx000E9;s exclusivement x000E0; l'usage > de la personne x000E0; laquelle ils sont adressx000E9;s. Si vous avez > rex000E7;u ce message par erreur, merci de le retourner x000E0; son > x000E9;metteur. Les idx000E9;es et opinions prx000E9;sentx000E9;es dans ce > message sont celles de son auteur, et ne reprx000E9;sentent pas > nx000E9;cessairement celles de DANONE ou d'une quelconque de ses filiales. > La publication, l'usage, la distribution, l'impression ou la copie non > autorisx000E9;e de ce message et des attachements qu'il contient sont > strictement interdits. > > This e-mail and any files transmitted with it are confidential and intended > solely for the use of the individual to whom it is addressed. If you have > received this email in error please send it back to the person that sent it > to you. Any views or opinions presented are solely those of its author and > do not necessarily represent those of DANONE or any of its subsidiary > companies. Unauthorized publication, use, dissemination, forwarding, > printing or copying of this email and its associated attachments is strictly > prohibited. > > >
-- R125
125_condformat.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
