- CONDITIONAL FORMATING WITH SPREADSHEET CONVERTER HOW TO
- CONDITIONAL FORMATING WITH SPREADSHEET CONVERTER WINDOWS
For solving this, at first glance, complicated task it will be enough to make just a few clicks by mouse.įor example you need to find to the same number of transactions in the column E of the source table. The exposure by color of the duplicates is one of the most popular tasks, in which is very handy to utilize the conditional formatting.
How to highlight with color to duplicate values in excel?
In the column D has been automatically formatted the numeric values in the appropriate monetary currency.
Click on the button «Format» and in the window that appears «Format Cells», on the tab «Number» select to the specify currency of EUR. To do this, click on the appropriate button, and enter the formula: =F2"USA" After clicking on the windows «Format Cells» and «New Formatting Rule», you need to press OK and go back to the window Manager. Click on «Format» button and in the new window «Format Cells» in the tab «Number» select the appropriate currency as shown in the picture. And in the input box enter the formula: =F2="USA". Select: in window «New Formatting Rule» select the option «Use a formula to determine the which cells to format». In the new window «Conditional Formatting Rules Manager» click on the button «New Rule». 
Highlight to the cell range D2:D13 and select to the tool: «HOME» - «Styles» - «Conditional formatting» - «Manage Rules». Let`s create the new rule with the formula: if it the amount of any country from the EU – the result is in Euro-currency. if it the amount of USA – so the result is in dollars. The data in the «Result» column will be formatted in this way: The table transaction of settlements with different countries in Euro currency: How to convert the number in a money format by condition?
0 kommentar(er)
