Conditional formatting of a field on a sharepoint list by month of a date

as you can see in the picture, I have a date type field and I would like this field only to be displayed in orange when the month of the date is equal to the month of the current date but I don’t not see how to do it. Anyone have any idea for this?

=

sharepoint online – Power Apps custom form question on formatting

I’ve designed a custom input form for a Sharepoint list in Power Apps, and I had two questions on formatting:

  1. My formatting in preview mode looks fine, however once published in the Sharepoint list itself the field heights, text positioning, etc. is changed. Any idea how I can ensure that the formatting of the form remains consistent from Power Apps to Sharepoint? For reference, the formatting is shown below.

  2. Upon opening the form in Sharepoint, certain fields (see Issue Type, Priority, Status in the images below) in the form are highlighted/selected without any action on my end – any thoughts on how to remove this?

Custom form in Power Apps previewer:

enter image description here

Custom form in Sharepoint:

enter image description here

Thanks in advance!

Does a boot USB made with Rufus or other USB formatting tools work on Chromebook?

I got a Chromebook for school–specifically a Lenovo N22–and I have the means to make it run Gallium OS, I just want to make sure I don’t break anything before I do so.

I’ve heard Chrome OS has the ability to make boot USBs built in, which makes me think there might be some compatibility issues if I use a USB made by another program on another system.

json formatting – Lists: Show image overlay on mouse over

This might not be exactly what you need, but here is a good start.

In order to display a custom hover card, you need to use customCardProps element. See more details here. It has the following properties:

openOnEvent

  • hover – card appears on mouse hover;
  • click – card appears on click on the field.

directionalHint

  • topCenter bottomCenter leftCenter rightCenter
  • isBeakVisible – boolean. if true the card has a beak.

How to display an image using JSON formatting

{ 
  "elmType": "img",
  "attributes": {
    "src":  "[$Photo]" 
  }
}

And here is a complete script

{
    "elmType": "div",    
    "attributes": {
        "iconName": "Search"
    },
    "customCardProps": {
        "openOnEvent": "hover",
        "directionalHint": "rightCenter",
        "isBeakVisible": true,
        "formatter": {
            "elmType": "div",
            "style":{ "display": "block", "font-size": "15px", "padding": "10px" },
            "children": [
                {
                    "elmType": "div",
                    "style": { "display": "block", "width":"100%", "text-align": "center", "padding": "10px" },
                      "children":[
                      { "elmType": "img",
                            "attributes": {
                                "src":  "[$Photo]" 
                            }
                      }
                      ]
                   
                }
            ]
        }
    }
}

Result

enter image description here

json formatting – How to display past list items related to a column value?

In order to display a custom hover card, you need to use customCardProps element. See more details here. It has the following properties:

openOnEvent

  • hover – card appears on mouse hover;
  • click – card appears on click on the field.

directionalHint

  • topCenter bottomCenter leftCenter rightCenter
  • isBeakVisible – boolean. if true the card has a beak.

enter image description here

Sample JSON

{
    "elmType": "div",
    "txtContent": "@currentField.title",
    "customCardProps": {
        "openOnEvent": "hover",
        "directionalHint": "rightCenter",
        "isBeakVisible": true,
        "formatter": {
            "elmType": "div",
            "style":{ "display": "block", "font-size": "15px", "padding": "10px" },
            "children": [
                {
                    "elmType": "div",
                    "style": { "display": "block", "width":"100%", "text-align": "center", "padding": "10px" },
                      "children":[
                        {"elmType": "div", "txtContent":"Jour 1: 11-05-2021"},
                        {"elmType": "div", "txtContent":"Jour 2: 12-05-2021"},
                        {"elmType": "div", "txtContent":"Jour 3: 13-05-2021"},
                        {"elmType": "div", "txtContent":"Jour 4: 14-05-2021"}
                      ]
                   
                }
            ]
        }
    }
}

In your case, you will have to create a new multiline field that would include all this information. Then, you can create a Power Automate flow that is responsible for populating this new field automatically.

This way, your JSON formula will simply need to reference a single field to display correct content.

You can make your card as fancy as you want. For example:

enter image description here

conditional formatting – Using a custom formula on a sheet that is constantly expanding

A custom formula for 5 possible colors, by day is used to highlight entries by DayOfWeek

Is it possible to use a format like A2:A instead of manually editing it as the sheet grows bigger?

Formula works fine, just don’t want to be editing it continuously

Example for rows A2 to A641 – can this be $A$2:$A ?

=and(isblank($A$2:$A$641)=false,OR(weekday($A$2:$A$641)=7))

How do I apply more than one conditional formatting rule using JSON to a SP Online List column?

You cannot apply multiple JSON formatting codes to single column. So, you have to manage multiple conditions/rules within same JSON.

For changing color to red when number is negative, add below code in your existing JSON:

...

"style": {
      "color": "=if(@currentField < 0, 'red', '#323130')"
}

...

Documentation: Use column formatting to customize SharePoint

Are there any good guidelines around the formatting and display of amounts and numbers in UI, especially for high-density tables?

This might include the alignment of numbers in tables based on type of numerical data, and how to show multi-currency, and negative numbers on a variety of form factors.

conditional formatting – MS Excel How to Hide or Change Color of text in a cell with no value

I created a multi-page spreadsheet file originally in LibreOffice Calc (herein after “Calc”) and I am now working with it using Microsoft Excel. This is a tool I use to create a week-based report of stores I need to visit. There’s a separate data entry sheet, and then four successive report sheets, each identical in layout but each one showing the next successive set of entries. This enables me to enter up to one month’s worth of scheduling.

Some days, I am not visiting a particular store. On such a day, I would leave the store number cell blank on the data entry sheet. On the corresponding report entry for that day, I expect all the cells containing formulas (mostly vlookup formulas, but some just straight math formulas) to appear blank. Now, whether I’m using Calc or Excel, I expect that the default thing it will do is to show me some kind of message stating there’s no valid data to display. Both show the statement “#N/A”. What I want to happen is to change that text to white, so that the cell appears to be blank. The fact that “#N/A” is actually in there doesn’t matter.

In Calc, I’m able to use Conditional Formatting to control for this, wherein I tell it if the cell’s value doesn’t equal anything (strictly, if it’s equal to 0) then color the text white.

I can’t for the life of me get this to work in Excel. For laughs, I even tried the conditional value of “#N/A” and that also didn’t work. Does anyone here have an idea how I might achieve a similar result to what I get in Calc?

conditional formatting – MS Excel How to Hide or Change Color of text in a cell with no value

I created a multi-page spreadsheet file originally in LibreOffice Calc (herein after “Calc”) and I am now working with it using Microsoft Excel. This is a tool I use to create a week-based report of stores I need to visit. There’s a separate data entry sheet, and then four successive report sheets, each identical in layout but each one showing the next successive set of entries. This enables me to enter up to one month’s worth of scheduling.

Some days, I am not visiting a particular store. On such a day, I would leave the store number cell blank on the data entry sheet. On the corresponding report entry for that day, I expect all the cells containing formulas (mostly vlookup formulas, but some just straight math formulas) to appear blank. Now, whether I’m using Calc or Excel, I expect that the default thing it will do is to show me some kind of message stating there’s no valid data to display. Both show the statement “#N/A”. What I want to happen is to change that text to white, so that the cell appears to be blank. The fact that “#N/A” is actually in there doesn’t matter.

In Calc, I’m able to use Conditional Formatting to control for this, wherein I tell it if the cell’s value doesn’t equal anything (strictly, if it’s equal to 0) then color the text white.

I can’t for the life of me get this to work in Excel. For laughs, I even tried the conditional value of “#N/A” and that also didn’t work. Does anyone here have an idea how I might achieve a similar result to what I get in Calc?