Tutorial by Examples

Highlighting Duplicate Values With Range("E1:E100").FormatConditions.AddUniqueValues .DupeUnique = xlDuplicate With .Font .Bold = True .ColorIndex = 3 End With End With Highlighting Unique Values With Range("E1:E100").FormatConditions.AddUniqueVa...

Highlighting Top 5 Values With Range("E1:E100").FormatConditions.AddTop10 .TopBottom = xlTop10Top .Rank = 5 .Percent = False With .Font .Bold = True .ColorIndex = 3 End With End With

With Range("E1:E100").FormatConditions.AddAboveAverage .AboveBelow = xlAboveAverage With .Font .Bold = True .ColorIndex = 3 End With End With Operators: NameDescriptionXlAboveAverageAbove averageXlAboveStdDevAbove standard deviationXlBelowAverageBelow ...

You need to include the Pagination.php in your page/s. require_once 'Paginator.php'; $Paginator = new Paginator('mysql:host=localhost;dbname=ng_app', 'root', '000000'); $Paginator->setItemLimitPerPage(4); $Paginator->setTable('comments'); $Paginator->createPages(); // this will creat...

Range("a1:a10").FormatConditions.AddIconSetCondition With Selection.FormatConditions(1) .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl3Arrows) End With With Selection.FormatConditions(1).IconCriteria(2) .Type = xlConditionValueP...

This example shows how you might handle users interacting with modals on a 1-1 basis. //client side function modals(socket) { this.sendModalOpen = (modalIdentifier) => { socket.emit('openedModal', { modal: modalIdentifier }); }; this.closeModa...

Normally when rails environment is run by typing. This just runs the default environment which is usually development rails s The specific environment can be selected by using the flag -e for example: rails s -e test Which will run the test environment. The default environment can be change...

If running on a remote server that is using Passenger change apache.conf to to the environment you want to use. For example this case you see RailsEnv production. <VirtualHost *:80> ServerName application_name.rails.local DocumentRoot "/Users/rails/application_name/public" ...

This getting started assumes you are working with create-react-app, or something equivalent using Babel and all the goodies out there. Also check out the great documentation right here. First, install react-router-dom: npm install react-router-dom or yarn add react-router-dom. Then, create a com...

Detailed instructions on getting loadrunner set up or installed.

InputBox, userinput This will store what the user types into the input box in the variable named userinput

InputBox, password, Enter your Password,, HIDE,, 100 Loop, { if (errorlevel = 1) return if (password = "password") { MsgBox, The password is correct. return } else if (password != "password") { MsgBox, The password is incorrect. InputBox, password, Enter yo...

String hostName = args[0]; int portNumber = Integer.parseInt(args[1]); try ( Socket echoSocket = new Socket(hostName, portNumber); PrintWriter out = new PrintWriter(echoSocket.getOutputStream(), true); BufferedReader in = new BufferedReader( new Inpu...

WarehosueEntity findWarehouseById(@Param("id") Long id); List<WarehouseEntity> findWarehouseByIdIn(@Param("idList") List<Long> warehouseIdList);

Due to its computational goals, mathematical operations on arrays are straight forward in Fortran. Addition and subtraction Operations on arrays of the same shape and size are very similar to matrix algebra. Instead of running through all the indices with loops, one can write addition (and subtra...

Sending The Request Header $uri = 'http://localhost/http.php'; $ch = curl_init($uri); curl_setopt_array($ch, array( CURLOPT_HTTPHEADER => array('X-User: admin', 'X-Authorization: 123456'), CURLOPT_RETURNTRANSFER =>true, CURLOPT_VERBOSE => 1 )); $out = curl_exec($ch...

CREATE TABLE Table1 ( id INT UNSIGNED NOT NULL, created_on DATE NOT NULL, PRIMARY KEY (id) ) CREATE TABLE Table2 ( id INT UNSIGNED NOT NULL, personName VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) CREATE TABLE Table3 ( id INT UNSIGNED NOT NULL, accountName VA...

Basically to apply a theme for SearchView extracted as app:actionViewClass from the menu.xml, we need understand that it depends completely on the style applied to the underlying Toolbar. To achieve themeing the Toolbar apply the following steps. Create a style in the styles.xml <style name=&qu...

Detailed instructions on getting genetic-algorithm set up or installed.

Our TCP echo back server will be a separate thread. It's simple as its a start. It will just echo back whatever you send it but in capitalised form. public class CAPECHOServer extends Thread{ // This class implements server sockets. A server socket waits for requests to come // in ove...