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 🙂
Conditional formatting not working properly as one of the comparing cells contains a vlookup formula
Hi, I'm having problems with a simple conditional formatting as one of the comparing values is a vlookup formula and not a number. I did the comparison with another set of data containing just numbers and not values and it works perfect. Is there any way to let the conditional format know that we need to compare the values of column A with the values of column B which gets filled with a VLookup formula and then highlight the cells containing different values? Please see the pictures. In this case, the conditional format is working as Column Brand has been input manually typing the numbers and the red cells are those ones showing differences between Column Inventory and Column Brand. In this case, the conditional format is not working. Column Available inventory is filled as a result of a Vlookup formula. Column Inventory and Column Avail. Inv. are all red for some reason. I think this is because when the conditional formatting compares Columns Inventory with Avail, everything is different as Column Avail's cells contain a formula and not a value. My comparing formula for the conditional format is very easy =$B2<>$H2 (Fill with red all cells from rows B and H with values are different from each other). Does any one have an idea about this? Does any one have had the same problem? Does anyone knows how to solve this? Thank you. Odin.
Conditional Formatting for One Word
I have a column in my spreadsheet with descriptors written by several different people so the language isn't consistent. I'd like to use conditional formatting to find cells with one particular word. Is there a way I can do that? I tried to make a new rule to format only cells containing the one word of text, but nothing happens. Is that because that's not the only word in the cell? Is there a way for me to do this? Here's an example of the data I am sorting. I want to highlight cells that have the word pending in them. Thank you! American Literature, Supplemental Literature Circles- Pending Senior English, core AP Language, Core Surplus by Newport Senior English, Supplemental- IB Core AP Language, Supplemental Honors 7, Supplemental Senior English, Supplemental Honors 7, Supplemental Senior English, Supplemental, AP Literature, Supplemental (SHS?) High School, Supplemental High School, Supplemental- Pending
Conditional Formatting SharePoint List
Hello team, I need your support with conditional JSON formatting of SharePoint list. I would like to format column INVEST_DUE_DATE based on current date (date cell) and based on value in column Phase (string). Right now, I implemented just formatting based on date, using following code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField < @now , '#f7adad', if(@currentField <= @now + 864000000, '#f2d596', if(@currentField >= @now + 864000000 , '#a0dec0', '')))" } } I want to apply additional condition for it - use color formatting only if value of cell Phase = Investigation. So , it should be something like this (@currentField < @now) and @[$Phase]='Investigation' , '#f7adad', and etc.... But it does not works.... Could you please advise me how to modify initial JSON code? Thank you in advance!
How can I copy Conditional Formatting on cells below while the formula changes along?
I have made a simple Excel spreadsheet for myself so that I can easily see who I've sent a connection request, who has accepted the request, who I've contacted and who has reacted positively. For each of these aspects I type in 'ja' when it fits the requirement of the aspect, if it doesn't I leave the cell empty. As you can see I have added a column (column G) in which the cells count the times that the cells on the left side contain the word "ja", I only did this in order to make the formula a bit easier to make. The thing is, I want to change the cells below column B into a certain colour based on the number that is counted in column G. This goes as such (number is meant for column G, colour is meant for column B): 1 = red, 2 = orange, 3 = yellow, 4 = green. In other words: If the number in G2 is 4, I want the colour of B2 to be green and if the number in G3 is 1 I want the colour of B3 to be red. Now I'll describe my problem. I understand what Conditional Formatting is and as you can see I already used it on cell B2. I want to attach the same rules, as described earlier, to the cells below B2 (I only captured a very small part of the spreadsheet in the picture, the file consists of many more cells), but I want B2 to be connected to G2, B3 to G3, B4 to G4 and so on. The problem is that if I copy the Conditional Formatting of B2 to the cells below, they all reference to the cell G2, they don't link to the right cell. Can someone tell me how I can copy the Conditional Formatting to the right cells in column B so that they connect/reference to the right cell in column G (cells in the same row)? Thank you in advance!
