Google Sheets Bulk Conditional Format Applier

WHAT IT DOES

Google Sheets Bulk Conditional Format Applier is a spreadsheet productivity tool that streamlines the process of applying conditional formatting rules to Google Sheets ranges. Instead of manually navigating through the Format menu, clicking Conditional formatting, selecting a rule type, setting conditions, choosing a color, and clicking Done—a process that can be repetitive when formatting multiple ranges—this script automates the entire workflow. It reads the current Google Sheets page, identifies the selected range, and allows you to apply a specified conditional format rule (single color or color scale) with customizable condition types (greater than, less than, equal to, text contains, date before, date after) and format colors. The tool handles the complete interaction sequence: opening the Conditional formatting menu, setting the range, configuring the condition, applying the color, and saving the rule. This is ideal for data analysts, spreadsheet users, and anyone who needs to apply consistent conditional formatting across multiple ranges or sheets.

WHERE IT RUNS

This script operates exclusively on Google Sheets (*.google.com/sheets/*) as a userscript injected through the BotGentz extension. It runs within the context of your current browser tab and cannot access other tabs, bookmarks, history, or downloads. The script reads the page DOM to identify the selected range from the Sheets interface, and interacts with Google Sheets' native UI controls—the Format menu, Conditional formatting panel, range inputs, condition dropdowns, value inputs, color pickers, and Done buttons—to apply formatting rules. All operations occur locally in your browser; no data is sent to external servers.

HOW TO USE

1. Open any Google Sheets document and select the range you want to format (click and drag to select cells).

2. Click the BotGentz extension icon and select "Google Sheets Bulk Conditional Format Applier" from the script list.

3. The panel opens on the right side of the page. It automatically detects and displays your selected range.

4. Select the "Format type": Single Color or Color Scale.

5. Select the "Condition" type: Greater Than, Less Than, Equal To, Text Contains, Date Before, or Date After.

6. Enter the "Condition value" (e.g., 100 for numeric conditions, or a text string for Text Contains).

7. Choose a "Format color" using the color picker.

8. Toggle "Confirm before apply" if you want a confirmation before applying.

9. Click "Apply Format to Selected Range" to apply the rule.

10. The script will open the Conditional formatting menu, configure the rule, and save it.

WHY IT WORKS WHERE OTHERS FAIL

Many Google Sheets automation tools fail because they attempt to call Google's internal API endpoints or rely on brittle DOM selectors that change with every Google Sheets UI update. This script takes a resilient approach: it locates the actual interactive DOM elements Google Sheets renders—the Format menu, the Conditional formatting menu item, the range input, the condition dropdown, the value input, the color picker, and the Done button—and triggers native click events and value changes on them, exactly as a human would. It uses two strategies to open the Conditional formatting menu: first trying the Format menu (the primary path), then falling back to the right-click context menu if needed. It sets values using both the native value setter and dispatches "input" and "change" events, ensuring Google's JavaScript UI registers the update. By interacting at the UI layer rather than the framework layer, it remains functional across Google Sheets' frequent code updates.

THE PANEL

The script uses BotGentz's BGPanel system, which provides a floating, draggable panel on the right side of your screen. Drag the panel by its header to reposition it anywhere on the page—the panel remembers its position per site and snaps to the nearest edge when released. Click the minimize button to collapse the panel to a small floating bubble; click the bubble to expand it back. Resize the panel vertically by dragging its bottom edge. Press the Escape key to close the panel entirely. All panel state (position, collapsed/expanded) is persisted locally using GM_setValue, so your preferences survive page reloads.

PLEASE NOTE

This userscript requires the free BotGentz browser extension—it is not a standalone application. Google Sheets periodically updates its website layout and UI components; if the script stops working, an updated version may be released. The script applies conditional formatting to the selected range; if no range is selected, it will default to the current cell. This script does not store, transmit, or process any of your Google Sheets data outside your local browser. It does not access your password, hidden inputs, or file inputs. All formatting operations are performed through Google Sheets' own authenticated session using the official user interface. Use responsibly and ensure you have selected the correct range before applying formatting.