How do I add multiple “plain” unformatted lines to my document without taking the formatting of the preceding row?

I’m trying to enter multiple un-formatted rows to my Excel worksheet, but it keeps giving me grey-shaded cells for the first two columns with the blurbs:

“Enter Description in this column under this heading”

“Enter Recorder Time in Days in this column under this heading”

when I click in the colored areas.

enter image description here

How do I add plain vanilla rows with no formatting to continue my data entry?

Thanks for any help!

What does the colon operator do in SharePoint column formatting JSON?

If you use the Fill background color template for formatting a date column on a modern SharePoint list/library, and you switch to Advanced mode to view the JSON, it makes extensive use of a colon (:) operator. This is undocumented and seems to work exactly like the ternary (?) operator – I tried replacing all the colon operators with ternary operators and the formatting behavior was unchanged.

What’s the significance of the colon (:) operator?

Example – this is the JSON generated by the Fill background color template:

{     "elmType": "div",     "style": {         "padding": "0 4px"     },     "attributes": {         "class": {             "operator": ":",             "operands": [                 {                     "operator": "==",                     "operands": [                         "@currentField",                         ""                     ]                 },                 "",                 {                     "operator": ":",                     "operands": [                         {                             "operator": "<",                             "operands": [                                 {                                     "operator": "Date()",                                     "operands": [                                         {                                             "operator": "toDateString()",                                             "operands": [                                                 "@currentField"                                             ]                                         }                                     ]                                 },                                 {                                     "operator": "Date()",                                     "operands": [                                         {                                             "operator": "toDateString()",                                             "operands": [                                                 "@now"                                             ]                                         }                                     ]                                 }                             ]                         },                         "sp-css-backgroundColor-successBackground",                         {                             "operator": ":",                             "operands": [                                 {                                     "operator": "==",                                     "operands": [                                         {                                             "operator": "Date()",                                             "operands": [                                                 {                                                     "operator": "toDateString()",                                                     "operands": [                                                         "@currentField"                                                     ]                                                 }                                             ]                                         },                                         {                                             "operator": "Date()",                                             "operands": [                                                 {                                                     "operator": "toDateString()",                                                     "operands": [                                                         "@now"                                                     ]                                                 }                                             ]                                         }                                     ]                                 },                                 "sp-css-backgroundColor-warningBackground",                                 {                                     "operator": ":",                                     "operands": [                                         {                                             "operator": ">",                                             "operands": [                                                 {                                                     "operator": "Date()",                                                     "operands": [                                                         {                                                             "operator": "toDateString()",                                                             "operands": [                                                                 "@currentField"                                                             ]                                                         }                                                     ]                                                 },                                                 {                                                     "operator": "Date()",                                                     "operands": [                                                         {                                                             "operator": "toDateString()",                                                             "operands": [                                                                 "@now"                                                             ]                                                         }                                                     ]                                                 }                                             ]                                         },                                         "sp-css-backgroundColor-errorBackground",                                         ""                                     ]                                 }                             ]                         }                     ]                 }             ]         }     },     "txtContent": "@currentField" }  

Conditional formatting cells with multiple conditions and relative references over a range

I have a Google spreadsheet with arbitrary data. Three adjacent columns (let’s say A, B and C) have been set up with Data Validation to only allow values from 1 to 10.

I’m looking for a way to validate that if all three columns of a single row (e.g. A4, B4 & C4) have a value of 10, all three cells should get formatted differently, let’s say a different background color for the sake of simplicity.

This formatting should apply to an entire range from A/B/C1 to A/B/C300, and here lies the problem.

I’ve tried many ways to do this with data validation, built-in functions and conditional formatting, but other than going row by row applying the formatting, I haven’t found an actually effective way to do this. Had to resort to the script editor and write a function called when onEdit() gets triggered, but this is slow and the coloring can actually be seen being applied when the code triggers because each row needs to be checked individually.

Is there any way to do this without having to resort to scripting, and without having to do it row by row?

What’s happened to formatting of Google search results in the last 48 hrs?

I’ve previously been able to keep Google Search fast and clean by disabling JavaScript but in the last 48 hrs (since May 20, 2019), they’ve changed something.

Now the results return with excess HTML formatting (see link to screenshot), with or without JavaScript. This makes for slower rendering, makes scanning long results-lists tedious, and hides or removes all of the clickable search parameters that existed before.

Now if I want to access any of these I have to go through Advanced Search to add them to the search page (as in my screenshot). Even eBay allows reversion to their “Classic” view when they screw with appearance, so has anyone else experienced this new Google for Babies styling excess since May 20, 2019 and managed to get rid of it?

I use Firefox ESR (because I use Windows XP) and would like to understand what has changed at Google’s end rather than hear that I need to change my browser/OS/hardware.

Is this an HTML5 thing, or just the latest Firefox Fail after the recent plug-in signing debacle?

Google screenshot

Changing cells formatting based on another cells date

Ive been looking and cant quite find the answer im looking for.

I have a a spread sheet with columns Monday through Saturday with data lining up underneath. I would like the current day to highlight so i can read it easier. I can get the date cell to turn but not the rest. Youll see what i mean in the picture. i want all the cells under Wednesday to change color, then for it all to shift when the next day comes. P.S. im a newb.

enter image description here

What arguments in favor of automatic, mandatory, uniform code formatting in a software project?

I am the manager of a small team of software engineers.

I am looking for arguments in favor of automatic, mandatory code formatting.

For me it is natural, it goes with the Quality Assurance process and I do not question it too much ; commit cannot be accepted in our Python software if it does not passes through black. Many projects work the same.

But my lead developer is against this kind of formatting and I would like to have more arguments if someone can help 🙂

Is it possible to add formatting (such as bold and italics) to the description of a Facebook event page?

I manage the Facebook page for an Orchestra, and the plain text format of the event description makes it difficult to create a readable listing. I’d like to be able to use bold, italics, bullets, etc., in the description of these Facebook events. Is there any way to do this (or perhaps even include arbitrary HTML)?

excel formula using conditional formatting

Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell by 18 months, if it is between 9-12 months of another cell I would like to have it highlighted.

So for example cell A1= 2/1/2019 cell B1= 7/1/2020

I want cell B1 to be green if it is 18 months or greater than cell A1

I want B1 to be blue if it is between 15-17 months less than cell A1

I want B1 to be yellow if it is 14 months or less than cell A1

Hoping you can help please.