sr. ricco,
normal condicional formatear: 3 formatos condicionales + 1 formato predefinido = 4 formatos
el formato de la costumbre de la célula: 2 formatos condicionales + 1 formato predefinido = 3 formatos
la combinación de formato de costumbre de célula y formato condicional normal: 3 formatos condicionales + 2 formatos condicionales + 1 formato predefinido = 6 formatos
vea el archivo
mr. ricco,
normal conditional formatting :
3 conditional formats + 1 default format = 4 formats
cell custom format :
2 conditional formats + 1 default format = 3 formats
combination of cell custom format and normal conditional format :
3 conditional formats + 2 conditional formats + 1 default format = 6 formats
see the file
On 4/30/06, ricco fernando <[EMAIL PROTECTED]> wrote:
Hola los grupos, arrepentido si pregunté otra vez. Tengo una célula que quiero aplicar un condicional formatear. (Creo que "Formatting Condition" de caled en su Excel). Los problemas son, quiero utilizar más de 4 condiciones para cambiar el color de los tipos de letra en la célula. ¿Es posible hacerlo sin macro?I work to explain in English. But mine is bad. "I will do formatting condition with >4 condition switching font color. How to act it with no macro?". I wish being explain in Spain. But english would be bueno.XL-mania make me amaze.Ricco Fernando
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| |
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| [EMAIL PROTECTED] atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni Anda tentang XL-mania di : |
| http://www.friendster.com/profiles/xlmania |
+-------------------------------------------------------------------+
SPONSORED LINKS
Business application software | Microsoft excel training | Microsoft excel tutorial |
Business application development | Microsoft excel help | Microsoft excel training course |
YAHOO! GROUPS LINKS
- Visit your group "XL-mania" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
six_conditional_formatting.xls
Description: MS-Excel spreadsheet