How to apply conditional formatting across an entire row based on text in a cell in Google Sheets

by
  1. Open the Google Sheets file
  2. Open on the menu bar Format >> Conditional formatting
  3. In the conditional formatting editing side panel, define the following settings
    • Range to apply the formatting (eg. A1:L99)
    • Format rules (see below)
    • Formatting style (eg. red text, yellow cell)
  4. Formatting rules to apply conditional formatting across an entire row based on text in a cell
    • Open the dropdown “Format cell if”
    • Select “Custom formula is”
    • Enter equal (=)
    • Enter the column where the relevant condition is to be evaluated
    • Enter the number of the row that corresponds to the upper row in the range range to apply the formatting (if range A1:L99 then enter eg. C1)
    • Enter equal (=)
    • Enter the text that should be present in the cell to trigger the conditional formatting (“text here”)
    • The dollar sign ($) will lock the column on which we want to base our conditional formatting. This is the key to highlighting the entire row.
    • Use formula without dollar sign ($) if you want to apply the conditional formatting on the fitting cells within the column
  5. Example to apply conditional formatting across an entire row based on text in a cell
=$C1="text here"

How to solve USB connection issues between computer and Rumba Taurino board

by

INTRODUCTION AND SCOPE

USB connection is an important feature to ensure the rumba taurino board remains operative. Unfortunately, problems can frequently arise. This procedure aims to explain how to solve USB connection issues between computer and Rumba Taurino board.

MATERIALS AND EQUIPMENT

Rumba taurino board, USB cable, Two-pins bridge.

PROCEDURE

  1. Switch on the computer (defined PC below). 3D printer or similar (defined device below) must be off.
  2. Under PC Device Manager (link: Start> Run> Driver) check if there are RUMBA TAURINO BOARD devices installed but not recognized (unknown). If there are unknown devices, remove them.
  3. With device off, identify the two pins highlighted in red (see Images sections). Short the two pins to switch to DFU mode (Device Firmware Update). More details on DFU mode can be found at the link provided under credits (link 3).
  4. Connect the USB cable to the PC and then to the device.
  5. Switch on the device.
  6. Wait for 10 seconds and then remove the short on the two pins (avoid making short-circuit with other pins). The LED of the serial communication (TX and RX) start blinking.
  7. PC detects new hardware and tries to install the driver. This automatic task should give a system error and fail to install any driver.
  8. Download the DFU programmer and the drivers for the USB connection of the Rumba Taurino board that can be found at the link provided under credits (link 1). Save it on PC and unzip it. This is the path of the driver and DFU programmer required in step 9 and 10.
  9. Open the tool for manual installation of drivers (link: Start> Run> hdwwiz). Select the option install from list, select show all devices, disk driver and insert the path where the drivers for the USB connection of the Rumba Taurino board are saved on the PC. From the list select ATmega16U2 to install the driver for the USB connection of the Rumba Taurino board.
  10. Run the DFU programmer to flash the USB port. If a message on memory error check appears, click a keyboard button to flash the port.
  11. If needed and if not already available on the PC, install the driver for Rumba Taurino board (not the USB driver installed in step 9!), that can be downloaded at the link provided under credits (link 2).
  12. Switch off the device and switch on again to verify that it is now recognized by the PC and a USB port is assigned. Under devices the Rumba Taurino board icon appears.

IMAGES

Rumba Taurino two pins to short
Rumba Taurino two pins to short

HARDWARE RESOURCES

See Credits.

SOFTWARE RESOURCES

See Credits.

CREDITS

  1. Rumba Taurino Board PC USB connection (github)
  2. RUMBA_TAURINO_DriverSetup (reprap)
  3. DFU Mode (arduino)

DISCLAIMER

The project is provided in the spirit of open source and can be implemented, modified and shared according to CC BY-SA license (see footer). No liability is taken for any issues arising from the provided information.

CHANGELOG

  • 07/JUN/2015 – New release
  • 16/FEB/2016 – Verbiage improved in step 2, Step 8 added, Description improved in step 9-10-11, Resource references improved with numbering
  • 05/OCT/2016 – Project structure improved with sections: Introduction and scope, Materials and Equipment, Procedure, Hardware resources, Software resources, Credits and Disclaimer.

This site uses cookies. If you consent, accept this message. For more options, read the Privacy Policy

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close