Export translations
Jump to:
navigation
,
search
Settings
Group
Abbreviate Labels
Abbreviate Legend
Accept shared dashboards
Account Creation
Adding an Object
Adding Columns to an Object
Advanced row filter
Alternate row colors
Applying Conditional Formatting
Area Chart
Automate Update data
Automatic Dashboard Generation
Automatic Execution
Average Column
Axis Values Properties
Background color
Bar Chart
Billing Data
Blocked Dashboards
Border color
Border thickness
Button Object
Buy Credits
Caption
Change password
Chart Axes
Clear a Data Source
Cloud Based
Column background color
Column Chart
Column Data Properties
Column filters
Column font
Column font color
Column font size
Column font style
Column Header Properties
Column label
Column Layout Properties
Column name
Column order
Column Properties
Column Properties Tutorial
Column width
Columns Data Type
Combo (Filter)
Combo (Filter) Tutorial
Combo Filter Selection
Conditional Formatting
Conditional Formatting Tutorial
Contact Share Required
Control Panel
Copy Dashboards to other users
Creating Dashboards with TaticView
Cross Area Chart
Cross Bar Chart
Cross Column Chart
Cross Line Chart
Cross Table
CSV Importing Guide
Custom date shortcuts
Customize Subscription
Dashboard
Dashboard dimensions
Dashboard Examples
Dashboard Properties
Dashboards Design
Dashboards Management
Data Properties
Data Sources
Data Sources Management
Data type
Date
Date Anchors
Date shortcuts
DeactivateUser
Decimal (Y axis)
Decimal places
Delete column
Delete Dashboards
Delete Data Source
Description
Design Options and Tools
Design Overview
Design Overview Tutorial
Drill Down
Edit dashboard
Edit Template
Escape Char
Excel Importing Guide
Execute a Dashboard
Export CSV
Expressions
Extract
FAQ
Features
Features Modifications
File
File and identification
Filters
Font
Font color
Font size
Font style
Frozen Column
Function
Gauge
Gauge Background Color
Gauge ranges
Gauge Tutorial
Generate dashboards
Getting Started
Grid line color
Header Properties
Help Index
Hibernation
Hide Border
Hide Category
Hide labels
Hide Legend
Hide values
Hotkeys
Hyperlinks
Hyperlinks Configuration
Image
Image (Icon)
Import/Update data
Importing a New Data Source
Importing a New Data Source Tutorial
Importing Problems
Input Data Format
Invoices
Java JRE install and troubleshooting
Keep aspect ratio
Label
Label (series)
Labels position
Labels rotation
Layout Properties
Legend position
Legend Properties
Line
Line Chart
Line color
Line thickness
Log Off
Main Page Overview
Manage Access
Manage Dashboards Groups
Mask
Maximum Axis Value
Minimum Axis Value
Mobile app
Mobile Development
Modifying Properties
More details
Name
New dashboard
New Data Source Summary
Number Formatting
Object and Column Filters
Object dimensions
Object Filters
Object Operations
Object positions
Objects
Objects Mosaic
Permission filters
Pie Chart
Pie Chart Tutorial
Properties
Provide Template
Rectangle
Reference column
Release Notes
Resolution
Retrieve your password
Row limit
Rows sort
Running via URL
Save File Supported Format
Security
Security Announces
Selected column
Sequence column
Series Color
Series Properties
Series Type
Share dashboards
Share status
Sharing a Dashboard Tutorial
Sharing Dashboards with TaticView
Show Markers
Show Pager
Show value as
Sign In
SlideShow
Sort Dashboards
Sort Data Source
Special
Stacking
Subscription Exceeded
Subscription Features
Subscription Plans
Subscriptions
Supported File Formats
Table
Tables Tutorial
TaticView
TaticView:About
Template Condominium
Template ERP Pronto
Template Focco ERP
Template Fuel Station
Template RH
Template Sadig Performance (BSC Projects)
Template Sadig Performance (Metrics Groups)
Template Sales
Template Tutorial
Template Windel ERP
Templates
Terms of use Templates
Text
Text alignment
Thousand sep.
Thousand sep. (Y axis)
Title bar Properties
Total column
Total row
Transfer
Transparency
TVCli
TVCli Commands
TVCli Commands Reference
TVCli Download
Use Expressions
Use template
User profile
Using TaticView
Value
Video Tutorials
Write permission
Language
aa - Qafár af
ab - Аҧсшәа
ace - Acèh
ady - адыгабзэ
ady-cyrl - адыгабзэ
aeb - تونسي/Tûnsî
aeb-arab - تونسي
aeb-latn - Tûnsî
af - Afrikaans
ak - Akan
aln - Gegë
am - አማርኛ
an - aragonés
ang - Ænglisc
anp - अङ्गिका
ar - العربية
arc - ܐܪܡܝܐ
arn - mapudungun
arq - جازايرية
ary - Maġribi
arz - مصرى
as - অসমীয়া
ase - American sign language
ast - asturianu
atj - Atikamekw
av - авар
avk - Kotava
awa - अवधी
ay - Aymar aru
az - azərbaycanca
azb - تۆرکجه
ba - башҡортса
ban - Basa Bali
bar - Boarisch
bbc - Batak Toba
bbc-latn - Batak Toba
bcc - جهلسری بلوچی
bcl - Bikol Central
be - беларуская
be-tarask - беларуская (тарашкевіца)
bg - български
bgn - روچ کپتین بلوچی
bho - भोजपुरी
bi - Bislama
bjn - Bahasa Banjar
bm - bamanankan
bn - বাংলা
bo - བོད་ཡིག
bpy - বিষ্ণুপ্রিয়া মণিপুরী
bqi - بختیاری
br - brezhoneg
brh - Bráhuí
bs - bosanski
bto - Iriga Bicolano
bug - ᨅᨔ ᨕᨘᨁᨗ
bxr - буряад
ca - català
cbk-zam - Chavacano de Zamboanga
cdo - Mìng-dĕ̤ng-ngṳ̄
ce - нохчийн
ceb - Cebuano
ch - Chamoru
cho - Choctaw
chr - ᏣᎳᎩ
chy - Tsetsêhestâhese
ckb - کوردی
co - corsu
cps - Capiceño
cr - Nēhiyawēwin / ᓀᐦᐃᔭᐍᐏᐣ
crh - qırımtatarca
crh-cyrl - къырымтатарджа (Кирилл)
crh-latn - qırımtatarca (Latin)
cs - čeština
csb - kaszëbsczi
cu - словѣньскъ / ⰔⰎⰑⰂⰡⰐⰠⰔⰍⰟ
cv - Чӑвашла
cy - Cymraeg
da - dansk
de - Deutsch
de-at - Österreichisches Deutsch
de-ch - Schweizer Hochdeutsch
de-formal - Deutsch (Sie-Form)
din - Thuɔŋjäŋ
diq - Zazaki
dsb - dolnoserbski
dtp - Dusun Bundu-liwan
dty - डोटेली
dv - ދިވެހިބަސް
dz - ཇོང་ཁ
ee - eʋegbe
egl - Emiliàn
el - Ελληνικά
eml - emiliàn e rumagnòl
en - English
en-ca - Canadian English
en-gb - British English
eo - Esperanto
es - español
es-formal - español (formal)
et - eesti
eu - euskara
ext - estremeñu
fa - فارسی
ff - Fulfulde
fi - suomi
fit - meänkieli
fj - Na Vosa Vakaviti
fo - føroyskt
fr - français
frc - français cadien
frp - arpetan
frr - Nordfriisk
fur - furlan
fy - Frysk
ga - Gaeilge
gag - Gagauz
gan - 贛語
gan-hans - 赣语(简体)
gan-hant - 贛語(繁體)
gcr - kréyòl gwiyanè
gd - Gàidhlig
gl - galego
glk - گیلکی
gn - Avañe'ẽ
gom - गोंयची कोंकणी / Gõychi Konknni
gom-deva - गोंयची कोंकणी
gom-latn - Gõychi Konknni
gor - Bahasa Hulontalo
got - 𐌲𐌿𐍄𐌹𐍃𐌺
grc - Ἀρχαία ἑλληνικὴ
gsw - Alemannisch
gu - ગુજરાતી
gv - Gaelg
ha - Hausa
hak - 客家語/Hak-kâ-ngî
haw - Hawaiʻi
he - עברית
hi - हिन्दी
hif - Fiji Hindi
hif-latn - Fiji Hindi
hil - Ilonggo
ho - Hiri Motu
hr - hrvatski
hrx - Hunsrik
hsb - hornjoserbsce
ht - Kreyòl ayisyen
hu - magyar
hu-formal - magyar (formal)
hy - Հայերեն
hz - Otsiherero
ia - interlingua
id - Bahasa Indonesia
ie - Interlingue
ig - Igbo
ii - ꆇꉙ
ik - Iñupiak
ike-cans - ᐃᓄᒃᑎᑐᑦ
ike-latn - inuktitut
ilo - Ilokano
inh - ГӀалгӀай
io - Ido
is - íslenska
it - italiano
iu - ᐃᓄᒃᑎᑐᑦ/inuktitut
ja - 日本語
jam - Patois
jbo - la .lojban.
jut - jysk
jv - Basa Jawa
ka - ქართული
kaa - Qaraqalpaqsha
kab - Taqbaylit
kbd - Адыгэбзэ
kbd-cyrl - Адыгэбзэ
kbp - Kabɩyɛ
kg - Kongo
khw - کھوار
ki - Gĩkũyũ
kiu - Kırmancki
kj - Kwanyama
kk - қазақша
kk-arab - قازاقشا (تٴوتە)
kk-cn - قازاقشا (جۇنگو)
kk-cyrl - қазақша (кирил)
kk-kz - қазақша (Қазақстан)
kk-latn - qazaqşa (latın)
kk-tr - qazaqşa (Türkïya)
kl - kalaallisut
km - ភាសាខ្មែរ
kn - ಕನ್ನಡ
ko - 한국어
ko-kp - 한국어 (조선)
koi - Перем Коми
kr - Kanuri
krc - къарачай-малкъар
kri - Krio
krj - Kinaray-a
krl - karjal
ks - कॉशुर / کٲشُر
ks-arab - کٲشُر
ks-deva - कॉशुर
ksh - Ripoarisch
ku - kurdî
ku-arab - كوردي (عەرەبی)
ku-latn - kurdî (latînî)
kum - къумукъ
kv - коми
kw - kernowek
ky - Кыргызча
la - Latina
lad - Ladino
lb - Lëtzebuergesch
lbe - лакку
lez - лезги
lfn - Lingua Franca Nova
lg - Luganda
li - Limburgs
lij - Ligure
liv - Līvõ kēļ
lki - لەکی
lmo - lumbaart
ln - lingála
lo - ລາວ
loz - Silozi
lrc - لۊری شومالی
lt - lietuvių
ltg - latgaļu
lus - Mizo ţawng
luz - لئری دوٙمینی
lv - latviešu
lzh - 文言
lzz - Lazuri
mai - मैथिली
map-bms - Basa Banyumasan
mdf - мокшень
mg - Malagasy
mh - Ebon
mhr - олык марий
mi - Māori
min - Baso Minangkabau
mk - македонски
ml - മലയാളം
mn - монгол
mo - молдовеняскэ
mr - मराठी
mrj - кырык мары
ms - Bahasa Melayu
mt - Malti
mus - Mvskoke
mwl - Mirandés
my - မြန်မာဘာသာ
myv - эрзянь
mzn - مازِرونی
na - Dorerin Naoero
nah - Nāhuatl
nan - Bân-lâm-gú
nap - Napulitano
nb - norsk bokmål
nds - Plattdüütsch
nds-nl - Nedersaksies
ne - नेपाली
new - नेपाल भाषा
ng - Oshiwambo
niu - Niuē
nl - Nederlands
nl-informal - Nederlands (informeel)
nn - norsk nynorsk
nov - Novial
nrm - Nouormand
nso - Sesotho sa Leboa
nv - Diné bizaad
ny - Chi-Chewa
nys - Nyunga
oc - occitan
olo - Livvinkarjala
om - Oromoo
or - ଓଡ଼ିଆ
os - Ирон
pa - ਪੰਜਾਬੀ
pag - Pangasinan
pam - Kapampangan
pap - Papiamentu
pcd - Picard
pdc - Deitsch
pdt - Plautdietsch
pfl - Pälzisch
pi - पालि
pih - Norfuk / Pitkern
pl - polski
pms - Piemontèis
pnb - پنجابی
pnt - Ποντιακά
prg - Prūsiskan
ps - پښتو
pt - português
pt-br - português do Brasil
qu - Runa Simi
qug - Runa shimi
rgn - Rumagnôl
rif - Tarifit
rm - rumantsch
rmy - Romani
rn - Kirundi
ro - română
roa-tara - tarandíne
ru - русский
rue - русиньскый
rup - armãneashti
ruq - Vlăheşte
ruq-cyrl - Влахесте
ruq-latn - Vlăheşte
rw - Kinyarwanda
sa - संस्कृतम्
sah - саха тыла
sat - Santali
sc - sardu
scn - sicilianu
sco - Scots
sd - سنڌي
sdc - Sassaresu
sdh - کوردی خوارگ
se - davvisámegiella
sei - Cmique Itom
ses - Koyraboro Senni
sg - Sängö
sgs - žemaitėška
sh - srpskohrvatski / српскохрватски
shi - Tašlḥiyt/ⵜⴰⵛⵍⵃⵉⵜ
shi-latn - Tašlḥiyt
shi-tfng - ⵜⴰⵛⵍⵃⵉⵜ
shn - ၽႃႇသႃႇတႆး
si - සිංහල
sk - slovenčina
skr - سرائیکی
skr-arab - سرائیکی
sl - slovenščina
sli - Schläsch
sm - Gagana Samoa
sma - Åarjelsaemien
sn - chiShona
so - Soomaaliga
sq - shqip
sr - српски / srpski
sr-ec - српски (ћирилица)
sr-el - srpski (latinica)
srn - Sranantongo
ss - SiSwati
st - Sesotho
stq - Seeltersk
sty - cебертатар
su - Basa Sunda
sv - svenska
sw - Kiswahili
szl - ślůnski
ta - தமிழ்
tay - Tayal
tcy - ತುಳು
te - తెలుగు
tet - tetun
tg - тоҷикӣ
tg-cyrl - тоҷикӣ
tg-latn - tojikī
th - ไทย
ti - ትግርኛ
tk - Türkmençe
tl - Tagalog
tly - толышә зывон
tn - Setswana
to - lea faka-Tonga
tpi - Tok Pisin
tr - Türkçe
tru - Ṫuroyo
ts - Xitsonga
tt - татарча/tatarça
tt-cyrl - татарча
tt-latn - tatarça
tum - chiTumbuka
tw - Twi
ty - reo tahiti
tyv - тыва дыл
tzm - ⵜⴰⵎⴰⵣⵉⵖⵜ
udm - удмурт
ug - ئۇيغۇرچە / Uyghurche
ug-arab - ئۇيغۇرچە
ug-latn - Uyghurche
uk - українська
ur - اردو
uz - oʻzbekcha/ўзбекча
uz-cyrl - ўзбекча
uz-latn - oʻzbekcha
ve - Tshivenda
vec - vèneto
vep - vepsän kel’
vi - Tiếng Việt
vls - West-Vlams
vmf - Mainfränkisch
vo - Volapük
vot - Vaďďa
vro - Võro
wa - walon
war - Winaray
wo - Wolof
wuu - 吴语
xal - хальмг
xh - isiXhosa
xmf - მარგალური
yi - ייִדיש
yo - Yorùbá
yue - 粵語
za - Vahcuengh
zea - Zeêuws
zh - 中文
zh-cn - 中文(中国大陆)
zh-hans - 中文(简体)
zh-hant - 中文(繁體)
zh-hk - 中文(香港)
zh-mo - 中文(澳門)
zh-my - 中文(马来西亚)
zh-sg - 中文(新加坡)
zh-tw - 中文(台灣)
zu - isiZulu
qqq - Message documentation
Format
Export for off-line translation
Export in native format
Fetch
{{DISPLAYTITLE:Conditional Formatting}}<languages/> Sets different formatting (styles) to rows, columns, and cells of normal and intersection tables based on conditions/selections (rules). These conditions can be a fixed value, a range of values, greater than a certain value, etc. [[File:mainmenu5.png]] [[Conditional Formatting Tutorial|See our video tutorial here]] Conditional formatting allows you to modify the following table rows and/or columns properties based on the condition set for each rule: * Rows, columns ([[Cross Table]]), and cells background color; * Font color; * Font styles (bold, italic, and underline); * Add icons (symbols) to cells (Only when the rule is applied to the columns. Except for the pivot 2 [[Cross Table]]). * Pick the symbol’s color; To facilitate the formatting settings, we have made available default formatting options where you just have to create the conditions to apply the formatting. There are two ways of applying the conditional formatting to the [https://taticview.com/en/ TaticView] tables. Apply rules through rows (object rules), which will be implemented to the table rows or apply rules through column/cell, where the formatting will only be applied to the table's columns/cells, or apply rules through column/cell, where the formatting will only be applied to the table's columns/cells. '''Rows rule''' This type of rule will be implemented to every row of the table if the rule condition is true. To create rules to table lines, all you have to do is select the desired object and select the option ''Conditional Formatting'' on the ''Object'' tab on the [[Design Overview#SideBar|sidebar]]. The following screen will be shown when you've created a new rule for a certain row. [[File:conditinal_formatting_line_rules_en-US.PNG|link=]] A rule will be automatically created where you'll have to choose what reference column, condition to the formatting implementation, and also the desired formatting. The rules for the rows can have the following properties edited: * Font styles (bold, italic, and underline); * Font color; * Background color; Besides, all these rules have the following pre-set formattings: * ''Blue background'' - applies a blue background to rows that fit into the rule condition. * ''Green background'' - applies a green background to rows that fit into the rule condition. * ''Yellow background'' - applies a yellow background to rows that fit into the rule condition. * ''Red background'' - applies a red background to rows that fit into the rule condition. We also provide a set of predefined rules to apply to the rows. This set of rules creates three rules applying different background colors to the rows. All you have to do is to set the reference column and the condition to apply the formatting. '''Columns rules''' The columns rules are applied only to the desired column or cell on which the condition is true. To create the rules for the columns/cells, you need to select the column where you want to apply the conditional formatting, and then click on the ''Conditional Formatting'' option on the ''Column'' tab on the design [[Design Overview#SideBar|sidebar]]. This type of rule also allows you to add symbols to the columns/cells. The following screen will be shown when you create a new rule to the columns. * If the column type is text: [[File:conditinal_formatting_column_text_rules_en-US.PNG|link=]] * If the column type is numeric: [[File:conditinal_formatting_column_numeric_rules_en-US.PNG|link=]] To facilitate use, just like the rules for the rows, rules are created automatically. You'll only have to define the condition and the formatting rule. One rule will be set to text columns and three for numeric columns. Besides, you can also create new rules or edit/delete an automatically created rule. The rules for the columns can have the following properties edited: * Font styles (bold, italic, and underline); * Font color; * Background color; * Icon; * Symbol color; Besides that, these rules also have the following predefined formatting: * ''Blue background'' - applies a blue background to rows that fit into the rule condition. * ''Green background'' - applies a green background to rows that fit into the rule condition. * ''Yellow background'' - applies a yellow background to rows that fit into the rule condition. * ''Red background'' - applies a red background to rows that fit into the rule condition. * ''Blue traffic light'' - Adds a blue traffic light to rows that fit into the rule condition. * ''Green traffic light'' - Adds a green traffic light to rows that fit into the rule condition. * ''Yellow traffic light'' - Adds a yellow traffic light to rows that fit into the rule condition. * ''Red traffic light'' - Adds a red traffic light to rows that fit into the rule condition. We also provide three predefined sets of rules to be applied to the columns/cells. * ''Background color'': Creates a set of rules that will be applied as Background Color to the selected column; * ''Traffic lights'': Creates a set of rules to apply traffic lights to the selected column; * ''Directional'': Creates a set of rules to apply directional arrows to the selected column; You will only need to configure the reference column ( the column that is going to be evaluated by the condition) and the condition to apply the rules. '''Apply on:''' The rules for the columns also allow them to be applied to ''Totals'' (total row and total column), ''Others'' row when they are shown in the tables and Drill down process. Be careful when applying the rules in the drill down, because some formatting may not reflect the test applied, especially when they are absolute values. [[File:rules-en+US.png|link=]] === Creating a rule === Click the button ''+ New Rule'' on the ''Conditional Formatting'' or use one of the predefined set of rules by clicking on the arrow next to this button. It is possible to select the reference column (the column that is going to be available), the condition to apply the rule and to define the value or range of figures that are going to be tested by the condition when you create a new rule. It is necessary to define the format of the condition for applying the rule after it has been configured. There are predefined formatting options, but it is possible to edit a custom formatting by clicking over the [[File:conditinal_formatting_editting_icon.PNG|link=]] icon. In this case, the following screen will be shown, allowing to edit the available properties. * ''Row rules'' [[File:conditinal_formatting_format_screen_line_en-US.PNG|link=]] * ''Columns rules'' [[File:conditinal_formatting_format_screen_column_en-US.PNG|link=]] You can add as many rules as you like. Examples of Rule Settings: [[File:Conditinal_formatting_line_rules_example_en-US.PNG|link=]] On the example above, three rules were added that modify the row's background color if the condition is true. [[File:conditinal_formatting_line_rules_example_2_en-US.PNG|link=]] In this example, it was added a rule that applies the bold font to the row. [[File:conditinal_formatting_column_rules_example_en-US.PNG|link=]] Here we are adding three symbols (traffic lights) determined by the values of the column and apllying in the totals. [[File:conditinal_formatting_column_rules_example_2_en-US.PNG|link=]] In this example, we are adding an alert symbol and applying italics when the ''Profit'' are below ''5,000.00''. === Deleting a rule === To delete a rule, you have to click the icon [[File:Conditinal_formatting_delete_icon.PNG|link=]] on the rule you want to remove. Use the button [[File:Conditinal_formatting_delete_all_icon.PNG|link=]] to delete all rules. === Changing the order of the rules === You have to click the icon [[File:conditinal_formatting_order_icon.PNG|link=]] and drag the rule to the desired position to change the order of the rules. Sometimes is necessary to change the order of the rules to define an application priority. For example, the last rule on the screen has priority over the first rule. In case the rules modify the same priority. The rules are applied individually if they modify different properties. <span style="color: red;">'''Important:'''</span> * The last rule has the preference in case two rules modify the same row/column priority (background color, font color, etc). * The columns/cells rules have priority over row rules. '''Applies to''' [[Table]], [[Cross Table]] === Examples of tables with applied rules === [[File:conditinal_formatting_example_en-US.PNG|link=]] [[File:conditinal_formatting_example_2_en-US.PNG|link=]] [[File:conditinal_formatting_example_3_en-US.PNG|link=]] [[File:conditinal_formatting_example_5_en-US.PNG|link=]] __NOTOC__
Navigation menu
Personal tools
English
Namespaces
Special page
Variants
Views
More
Search
Navigation
Main page
TaticView.com
TaticView App
Support
Get Support
FAQ
Help
Social Networks
Youtube
Facebook
LinkedIn
Tools
Special pages