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.


Kirim email ke