Conditional Formatting on whole column with variable reference cells
Hi, I'd like to format the colour fill of multiple cells within one particular column, when it's value is less than a cell in the row above of the next column. how should I do this please? eg. when the value of D93 is smaller than the value of E92 format fill red. Apply to all D's. So far I have established that if I type =($D$93<$E$92) then I can make the rule work for cell D93. But how can I replicate this formula throughout the whole of the D column, without typing for each individual cell. Is this even possible? Is there a short cut to copying the rules over? Thankyou 🙂SharePoint List Calendar View Conditional Formatting Not Displaying for Everyone
Good afternoon, I have an odd issue I'm struggling with. I've implemented some JSON code that changes the color of a Sharepoint calendar view event based on the event type. Most people see the color coding, however some people see all event types as one color (red). At first I thought it had to do with the level of MS access each user had (the first to flag it was an outside consultant), but a few others also experience this issue and their access levels range from Associate through Director. Has anyone else experienced this issue and know how to fix it? Thank you.
Conditional formatting - only show button if attachments are present
Hi, I am trying to only show a button in a column, if there is an attachment present in the same row on the attachment column. Here is what I have so far: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Send Offer", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"f191e7c8-1a36-4553-9d64-607764fc6f83\"}" }, "style": { "background-color": "blue", "color": "white", "visibility": "=if(([$Attachments] == false),'visible','hidden')" } } I have tried changing " [$Attachments] == false) " to equals true, 1 and 0, and there's still no use. If I look into the address bar I can see " FilterField1=Attachments&FilterValue1=1 ", but even when I enter "1" as the value the button still does not display when attachments are present. Any help is highly appreciated. Thank you!
Conditional formatting for decimals
Hello Experts, I am creating an excel sheet where user will have to put values with 4 decimal places. The value will turn red if it does not have four decimal places (i.e. more or less decimals places). I formatted the cells as number with four decimals and red font, so all input values become red (regardless of decimals places). Then, I applied the conditional formatting with formula =LEN($D6&"")-FIND(".",$D6&"")=4, and conditional formatted the font black, so all input values with four decimals turn black. Everything works fine till this stage. I have an issue while I put value with four decimals places, but zero at fourth decimal place (e.g. 1.1110). The excel doesn't consider trailing zero at a decimal, and doesn't convert the value to black. I am sure I am missing something here. Your support will be highly appreciated. Thanks in advance!!
Multi level group
Hi All, Within a document library view of sharepoint online, there seems to be a limit of 2 on the amount group by's that can be done. One of my clients needs to group on 3 or even more levels. My quetsions: - Is this functionality coming in future releases? - Is there any alternative to achieve this functionality? I am thinking of Conditional Formatting? Thanks in advance
