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"

A 13 years yourney…

by

13 years have elapsed from the first posts on pmoroni.it.
More than 500’000 people worldwide have visited the site, leaving comments, helping others with interesting information about travels, bioengineering, open source and social projects.
This is the power of using internet in the positive way.
Our mission is to continue in this journey with all of you.
A big, big thank you!

Lefkada and Porto Katsiki

by

From Patras and after passing the majestic Rion Antirion bridge, we salute the Peloponnese and return to mainland Greece. The landscape changes, the green increases and in the smile of the people we begin to glimpse a memory of the Balkans.
The island of Lefkada remains connected to the mainland by a strip of brackish land, where the road also runs. It is initially easy, but heading south, the situation is constantly getting worse. Once in Vassiliki we take to climb on a long limestone coast, up to the slope towards the west coast of Lefkada. Here the road becomes an increasingly faint track that grows with difficulty between dense forests of maritime pines and tiny villages. The landscape becomes increasingly wild and finally we see the spectacle of Porto Katsiki, a strip of beach surmounted by an impressive limestone cliff and lapped by an electric blue sea. We remain breathless.

Travel tip: reach the beach of Porto Katsiki in the evening of a long summer day, take a bath in the blue sea and remain suspended in the silence and darkness of the night.

Lefkada and Porto Katsiki, Grecia

Journey in the Peloponnese, from Monemvasia to Glifa

by

From Elafonisos and Monemvasia, the road climbs towards the fingers of the Peloponnese without stopping, curve after curve. Suddenly the splendid Sparta valley appears, green and luxuriant despite the summer heat. Here there is no trace of the times that were, when the Spartans dominated the ancient world, but still transpires a bucolic atmosphere sanctified by pastures and endless flocks of sheep.
After several hours we arrive at Pyrgos, where there is a sudden heat, the dust and the fear of some children who wash the windows at the many traffic lights that block the vehicles along the main road. A certain relief
it captures us when we see the sea again and we follow the dirt road that leads us to the campsite in Glifa.

Travel tip: wait for the sea to flow on the island of Zakynthos, sitting on the little beach of the Camping Ionion Beach

Journey in the Peloponnese, from Monemvasia to Glifa, Greece

Elafonisos, the beach and the hidden paradise

by

A day of bends and wild roads, a short ferry ride and finally we land on the almost Elafonisos peninsula. To welcome us an unexpected spectacle: a sheet of fine and soft white sand that slopes gently towards a placid and crystalline sea. Diving here is an unforgettable experience at 360 degrees: the water is so clean and transparent that you can observe the seabed for tens of meters, looking for fish and turtles caretta caretta that here still lay their eggs.

Travel tip: enjoy a sunset bath on the island of Elafonisos, out of season, in the silence of the wonderful Simos twin beach, between white dunes and turquoise sea, a stone’s throw from the homonymous Camping Simos

Elafonisos, the beach and the hidden paradise, Greece

Mycenae and the lost civilization

by

From Epidaurus we move quickly inland to the arid hills, destination of our next archaeological excursion, near the fortified acropolis of ancient Mycenae. We lose ourselves again in the Homeric accounts of Achaeans, Trojans and the love and warlike vicissitudes of the peoples who crossed the Aegean and the Peloponnese in the Archaic period.

In Mycenae we find good friends, an unexpected storm and a little rest after a few days of long journeys.

Travel tip: experience the thrill of being the only guests of the spartan Camping Atreus, right at the entrance to the modern village of Mycenae.

Mycenae and the lost civilization, Greece

Epidaurus and the ancient Greek theater

by

From Delphi we move in the busy direction of Athens but we take the painful decision not to stop, preferring to point directly towards the Peloponnese, which we reach suddenly when we pass over the spectacular Corinth canal. We also cover the historical stages that have filled our studies with notions, places like Salamina, Corinth, Thebes. From here the road proceeds tortuously along the eastern coast of the Peloponnese, until you reach New Epidaurus. Here a quiet town awaits us, good food, lots of new friends and a placid and mild sea.

Not far away, inland, the archaeological site of the ancient Epidaurus appears suddenly and unexpectedly, with its immense and spectacular semicircular theater, with exceptional acoustics, to be considered a worthy symbol of the Greek theater as it has come to us directly from the antiquities.

Travel tip: relax in the quiet bay of New Epidaurus, in the Camping Nicolas, literally one step away from the beach and the seashore.

Epidaurus and the ancient Greek theater, Greece

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