FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.

Detailed explanation-2: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.

Detailed explanation-3: -Conditional formatting enables you to apply special formatting to cells in your spreadsheet that meet certain criteria. Excel has a sizable library of preset conditions that you can apply fairly simply, or you can create your own conditional formatting rules using Excel formulas.

Detailed explanation-4: -Different than excel, conditional formatting in Tableau cannot be applied across a column but rather across a mark. Marks are generated when measures are added to the rows/columns shelf. Adding these additional marks allows a user to achieve a similar result to excel-like conditionally formatted crosstabs.