conditional-formatting Questions
2
Suppose I want to color scale complete rows on the basis of values in a column (using Google Sheets inbuilt color scale option in the conditional formatting menu). How do I achieve this?
Testimonial asked 11/12, 2019 at 19:22
8
Solved
I have some data that is accessible via:
{{ content['term_goes_here'] }}
... and this evaluated to either true or false. I'd like to add a class depending on the truthiness of the expression lik...
Allantoid asked 4/4, 2017 at 14:45
6
Solved
Suppose I want to color scale complete rows on the basis of values in a column (using excel inbuilt color scale option in the conditional formatting menu). How do I achieve this? Please see the fol...
Wabble asked 9/6, 2015 at 12:3
5
Solved
I cannot find a way to change the color of an Excel data bar based on value. Current formatting options only permit different colors based on positive/negative values. I'm currently using Excel 201...
Amadeus asked 4/6, 2015 at 1:11
6
I have written the function below to test if a cell has conditional formatting activated based upon the cell fill.
Function cfTest(inputCell)
If inputCell.DisplayFormat.Interior.Color <> 1...
Tactile asked 12/3, 2014 at 23:37
8
Solved
In my HTML structure, I have it set up like this:
<body>
<main>
<section>
...
</section>
<aside>
...
</aside>
</main>
</body>
The problem i...
Resemble asked 15/4, 2015 at 22:25
6
I'm trying to have a cell on Sheet A check if it's either > or < the value in a cell on Sheet B, then change its color accordingly. Under the custom formula I use: =A1>("SheetB!A1"), but it does...
Outstand asked 9/9, 2014 at 0:25
4
I'm doing some simple conditional formatting using xlsxwriter but I am getting this error when I run the code below.
AttributeError: 'Workbook' object has no attribute 'add_format'
I have update...
Focal asked 17/1, 2020 at 21:6
3
I'm running a piece of code via the Worksheet_Change Event and I have it working with a call to an unprotect sub at the beginning of the event and a matching call to a protect sub at the end of the...
Wampler asked 28/7, 2014 at 16:6
3
Solved
I want to find where two (or more) rows have the same x,y (location) but a different ID.
In the table below I would like to know about the last two rows only.
x
y
id
1
2
1
1
2
1
1
3
4
...
Hotchpotch asked 22/2, 2022 at 12:14
17
Using Offset or Indirect in 'Applies To' does not seem to work. Is there any other way to stop conditional formatting from breaking after inserting row/s
I have a conditional format for a range fo...
Bombproof asked 18/9, 2012 at 16:13
7
Solved
I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 based on the value of another cell - C5. If C5 is greater than 80% then the background color ...
Schumer asked 12/12, 2013 at 14:18
2
Solved
I have a strange problem, I have an excel document with two columns, col A contains the key, this is not unique, col b contains text of varying length, usually above 255 characters.
I'd like to ap...
Isaiah asked 4/8, 2018 at 19:17
1
Solved
I have this random dataframe containing two columns with dates, I've been trying to highlight rows where the start date exists inside a list of condition dates. Here goes my failed attempt:
import ...
Margarito asked 11/8, 2021 at 22:18
4
Solved
I'd like to apply a conditional formatting rule to a named range. Is that even possible? How do I do that? When trying to enter the Name of the Range to the Field where you set up the range the rul...
Ruyle asked 1/4, 2019 at 14:21
2
I want to create a conditional formatting rule where the cell will be highlighted if it also appears in a list (column A).
The values are all text (e.g "Apple", "Pear"). It has to be an exact matc...
Waits asked 28/10, 2018 at 15:20
1
Solved
There is a table of values in sheet 1 which I want to conditionally format(Highlight the cells in color
if the nested value finds a match in the table of sheet 2).
But it seems like vlookup functio...
Selwin asked 21/2, 2021 at 16:30
2
Solved
i have two data frame df1:
d1 = {"col1" : ['A', 'B', 'C'],
"Col2": ["home", "car","banana" ]}
d2 = {"col1" : ['D', 'F','C'],
"Col2": ["garden", "boat","banana" ]}
df1 = pd.DataFrame(data=d1)
d...
Biplane asked 30/4, 2018 at 12:32
5
Solved
I know you usually show what you've tried in a question, but this is more of a "Do you have a good routine that does this?" question and I'm hoping you'll be willing to let it slide...
I'm working...
Rhpositive asked 10/9, 2014 at 14:27
1
Solved
I have a flextable that I am trying to conditionally format percentage numbers based if they are > or less than a certain %. It's a simple conditional format so I'm not sure why it's not working...
Banda asked 4/7, 2020 at 14:7
6
Solved
I have a spreadsheet of symbols and matching hex colors. I want to fill the cell itself (or the one next to it) with the hex color within the cell. I've read a bit about "conditional formatting", a...
Circumstantiate asked 4/5, 2012 at 20:0
2
Solved
I have a spreadsheet with 250+ rows of data and need to find the largest value in each row. I tried to use Conditional Formatting, however I need the same rule for each row so can't highlight all t...
Goldfilled asked 27/11, 2015 at 17:7
6
I am looking for formula for google spreadsheet
highlight cell if value duplicate in same column
can anyone please assist me for this query?
Covin asked 20/2, 2014 at 6:3
1
Solved
In Google Sheets, I would like to highlight the max value in each row of a table.
I tried using conditional formatting, but without any success so far.
Mispronounce asked 18/8, 2019 at 14:11
2
Solved
My problem is about programming in excel (create a formula for conditional formatting rule).
If i use the following formula in my format condition formula:
=INDIRECT("A"&ROW())>1
And app...
Milium asked 8/1, 2017 at 2:57
1 Next >
© 2022 - 2024 — McMap. All rights reserved.