3,053 questions
1
vote
1
answer
60
views
Excel Conditional formatting tie breaking
I have a spreadsheet of prices from a selection of suppliers, with one supplier per column.
// Conditional Format code
=D2=MIN($D2:$K2)
I have used conditional formatting to highlight the cheapest ...
- 11
0
votes
0
answers
64
views
Conditional Formatting an Expanding Table [closed]
I have a table within a sheet for inventory. I have conditional formatting that will check the stock levels and highlight the row red when it's 0. This works perfectly.
However, when the table expands ...
Advice
0
votes
8
replies
141
views
Excel conditional formatting: how to format entire RELATIVE columns based on single row value
My question is quite straightforward - or at least, it should be!
I have an Excel sheet with dates and weekdays laid out across the top three rows. I want to highlight all columns in a particular ...
- 1,516
0
votes
1
answer
78
views
Openpyxl conditional formatting if cell among list values
I would like to use openpyxl to create an Excel conditional formatting rule where cells are filled with a particular color, when the cell value matches an element among a hardcoded list of values. The ...
- 1,314
0
votes
1
answer
103
views
VB.NET DataGridView not showing label row with EmpId and EmpName before attendance rows
What are you trying to do?
I'm building an attendance summary grid in VB.NET (Windows Forms). For each employee, I want to insert a label row before their daily attendance rows. This label row should ...
1
vote
1
answer
96
views
Conditional formatting in Excel for product codes with specific prefixes
I need an Excel conditional formatting formula or VBA to identify product names in a column to highlight cells red if the product name contains two or more sub-products (number+letter codes like r600, ...
- 13
0
votes
1
answer
68
views
Can I Create a Color Gradient Between Two Values in an Excel Pivot Table?
I need to conditionally format all values between 2 numbers in a pivot table using a color gradient to accentuate the scale of values between that range.
I'd like to not have any color for the rest of ...
- 21
2
votes
2
answers
118
views
Why does conditional formatting break when AND contains OFFSET?
I'm trying to use conditional formatting to color-code a schedule that repeats every 6 rows. The rule I'm using is =AND(OFFSET(C8,4-MOD(ROW(C8)-2,6),0)="TRAINING",MOD(ROW(C8)-2,6)<3).
...
- 47
2
votes
2
answers
87
views
Conditional formatting highlight non matching criteria based on min date
I'm attempting to create a conditional format that highlights a retail that doesn't match the rest of the retails in a product ID based on the earliest (min) date's retail.
In the below example I have ...
- 597
0
votes
0
answers
42
views
conditional formating to fill cell to percentage vba [duplicate]
I have a cell with a number. I want this cell to have a "progress bar" based on this value.
Manually I would do this by going to "conditional formatting" - "New Rule" and ...
2
votes
1
answer
95
views
Modifying the colors in David Bacci's PowerBI Deneb Org chart
I am trying to modify David Bacci's Org Chart. https://github.com/PBI-David/Deneb-Showcase/tree/main/Organisation%20Tree%20Chart. My goal is to change the color of the node borders based on ...
1
vote
1
answer
63
views
Color code cells of a tableGrob based on whether a value falls outside a certain range
I have a tableGrob object. I am looking to fill cells red when a value falls outside a certain threshold (specified by UDL and LDL in the dataframe below).
The data I'm working with:
structure(list(...
- 166
2
votes
1
answer
115
views
Excel - Nested IF(AND()) Statements to Report Multiple Parameters
My Objective:
In Excel, I need to identify 'Special' projects. The excel formula already identifies if a project has 'Not Started' and 'Ended,' as well as what year (year 1, year 2, year 3) the ...
- 930
0
votes
1
answer
53
views
Conditional formatting on sub-groups and whole data at the same time [closed]
I'm trying to create a custom formatting rule for a table where I have multiple columns that are grouped into sub-groups, like in below. It would be great if I can see at the same time from the table ...
- 61
2
votes
2
answers
68
views
Conditional formatting dependent on several variables
I have an Excel sheet that is meant to help with evaluating skills of employees. The sheet is formatted so that the employee names are in cells B1-AO1 and their respective job titles are in the row ...
- 23
0
votes
1
answer
49
views
How to performeExcel Conditional Formatting: Highlight "-" (except on Sundays) or time after 08:30
I'm working in Microsoft Excel (regional settings using semicolon ; as function separator), and I'm trying to set up conditional formatting on column G ("Start Time") based on the following ...
2
votes
1
answer
45
views
xlsxwriter conditional formatting formula only works after manual save
Here's the code I'm using:
row_sheet.conditional_format(f'$A$4:$A$10', {'type': 'formula',
'criteria':'=ISFORMULA()',
...
- 43
2
votes
0
answers
120
views
Conditional formatting of Gantt Chart in Power BI
I have a Gantt chart in PowerBI Desktop that models my sub-team's upcoming and current project efforts. Some of our projects are in a "prospecting with a projected timeline" status. We want ...
- 387
0
votes
1
answer
148
views
Need to identify rows where 3 columns have duplicates
I have a large data file. In this table, there are 3 columns with repeating information, but I need to identify the where the data has duplicates (x 3).
I haven't been able to try anything, as I am ...
2
votes
3
answers
93
views
Conditional Format Cells Fill based on criteria
I need to fill rows from A:D if Column A has text.
I tried a lot of codes.
I ended up recording macro. It fills only cells in Column A. How to replace "Selections" to a Range?
Columns("...
- 29
1
vote
1
answer
43
views
tableHTML conditional formatting misses values in range
Figures referenced below
I am new to R and RStudio, and landed on using the tableHTML package because it seems like a good fit to format my dataframe. I have a dataframe (tibia_outliers_shortable) ...
0
votes
1
answer
85
views
Google Sheets Conditional Formatting of a column based on formula
I cannot figure out the correct syntax to get the conditional formatting I need in google sheets.
In sheet1 I have column B with header name Count and then a sequence of 1 to 100 in the rows.
In ...
1
vote
2
answers
247
views
How to highlight lowest and second lowest values in a row, including duplicate values and ignoring zero
I'm trying to create conditional formatting for range K6:AF78 to highlight the lowest value(s) in each row green, and second lowest value blue. The problem I'm running into is when there are duplicate ...
- 13
0
votes
1
answer
84
views
Google Sheets conditional formatting - highlight cells in a row between two specific cells
I'm trying to conditional format cells in a row that are between two cells that have specific values.
I have found a conditional formatting custom formula using the 'COUNTA' function which formats all ...
- 15
0
votes
1
answer
76
views
Create Dynamic Named Range, based on adjacent value
Without using VBA (need to save as .xlsx), is there a way to create a dynamic named range?
Name Include
Dr. Nick Yes
Dr. Hibbert No
Dr. J No
Dr. Spaceman Yes
I am ...
- 23.5k
-1
votes
1
answer
106
views
Conditional coloring and outer borders in pdf KableExtra table in R
i have a simulated data frame in R that i want to conditional format the background of the cells (ie if the value is less than 30 to be red if is between 31 and 75 to be blue and 76 and above green). ...
- 1,348
2
votes
1
answer
192
views
Conditional formatting cells with exact text using openxlsx
I am exporting data into an xlsx file using the openxlsx R library, and wish to format cells conditionally based on the exact text they contain. To make the example simpler, let's pretend I want cells ...
- 241
0
votes
1
answer
65
views
Cell conditioning based on cell value on a row to cell value on column
Above is the cell values I want to apply the condition too.
A solution that works is to create a new column using the transpose function for the row in Question is to use the cell = cell.
I dont want ...
0
votes
0
answers
179
views
Excel conditional formatting with more than 253 discontiguous ranges
One conditional formatting definition can be applied to multiple (discontiguous) ranges of cells and Excel will find the "Lowest Value" and "Highest Value" etc for the limits of ...
- 183
0
votes
1
answer
190
views
Conditional selection of data in palantir contour
I have two datasets with Client, 1st Nationality, 2nd Nationality, 3rd Nationality and with Country Code, Continent.
I would need an expresion using an expresion board in Palantir Contour that would ...
- 537
0
votes
0
answers
31
views
DynamicJasper Conditional Style
I have just started DynamicJasper and trying to figure out how to apply conditional formatting.
I have these columns with data coming from Database.
AbstractColumn caTypeColumn = ColumnBuilder....
- 2,225
0
votes
1
answer
714
views
SharePoint Online List Column formatting - Hover to show Attachment preview
BOTTOM LINE UPFRONT
I Need pdf Attachment on SharePoint list items to show preview upon hovering.
IMPORTANT DETAILS
I'm using SharePoint Online.
The list has a column created by default called "...
- 11
0
votes
3
answers
174
views
conditional formatting to highlight the highest value in a row compared to all the columns before it
I am trying to figure out the conditional formatting formula to apply to a range of a row and have it highlight the value in the current cell if it is higher then all the values in the same row but ...
1
vote
1
answer
298
views
Conditional Format Cells with Special Characters including Accented Letters, Numbers, and Punctuation
I'm using Excel Version 2411, and I'm working on a file where I need to apply conditional formatting that will highlight a cell if the cell contains any characters that aren't ...
- 41
-1
votes
2
answers
126
views
Create and complete a conditional variable with existing and non-existing data [closed]
Attached data :
id = c(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
vm = c(6, 9, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, NA),
GE = c("1", "0", "0", "0"...
- 120
0
votes
0
answers
161
views
Create a border around a range if the date in a certain cell is the same as today [duplicate]
I'm using Google Sheets. My ultimate goal is to create a border around a variable range 'B', if the date in a certain cell, within a range 'A', is the same as "today".
For example:
There ...
- 1
0
votes
1
answer
37
views
Copying Conditionally formatted Cell colors from one sheet to another
I have two excel sheets
Sheet 1: has columns C6:M78 and is filled with the priority value
The priority ranges from 0-4 and I used conditional formatting to break this up into green, yellow, and red....
0
votes
1
answer
166
views
How to use Use a Formula to Determine Which Cells to Format to format a range of cells
I'm trying to create my own gantt chart with Excel as above.
I want to fill color for the cells in the zone of calendar with the help of "Conditional Formatting" but I don't know how to do ...
- 12.6k
0
votes
1
answer
117
views
Spotfire - Conditional Formatting - Color Scheme - Different Column Values
I have a cross table in Spotfire than I am trying to add a color scheme to but can't seem to figure out how to do it the way that I need it.
The image below isn't actual table obviously.
For this ...
- 61
2
votes
1
answer
65
views
R Reactable add prefix to column based on condition
I have a dataframe with two columns: Condition & Value.
Based on this dataframe I would like to create a reactable object.
The Value column should have a prefix.
It should be preceded by “Check” ...
- 1,463
-4
votes
1
answer
198
views
Conditional formatting using vlookups and dates
I’m trying to set up conditional formatting that uses vlookup to check a date against a tag, and if that date is less than a specific date, highlights it green. See attached data as example.
In the ...
0
votes
0
answers
85
views
PowerBI: Conditional Formatting on a Measure
Essentially, I need to create a table that lists out my product id’s based on categories identical to this video https://youtu.be/WSnB5y2JXv8?si=WQHOT__uKcEWAjTQ. But my issue is I have another color ...
0
votes
2
answers
78
views
Conditional Formatting in Google Sheets with another table INDIRECT
I want to highlight names in A7:A in color on the target sheet if a checkbox is marked in the source table "Data" (TRUE):
Source table "Data":
Column A:A = Checkbox
Column B:B = ...
- 165
0
votes
1
answer
31
views
Conditional Formatting (does not contain mulitple)
Help - how would I do conditional formatting formula to highlight entire row, where one column does not contain ULTD. OR UUS.
the following will work just using one criteria and only highlight rows ...
0
votes
3
answers
143
views
conditional formatting on a single cell where criteria is another column
Cell A1 contains the text "FLAG".
Column B contains dates.
I want to apply conditional formatting to cell A1 if any date in column B is less than 2 days from today(), and if the date is past ...
- 43
2
votes
0
answers
1k
views
Apache Superset - Conditional Formatting on a column based on the values of another column?
I am using a Pivot Table v2 in Apache Superset. I have two metric columns: 'Cost' and 'Percentage Diff.' (I'll refer to this as '%').
My goal is: for every row, the background color of the 'Cost' cell ...
0
votes
1
answer
123
views
Conditional Formatting for line chart in Power BI
Here I'm using line chart in PowerBI, including Plan vs Actual value. If Actual value is greater than the Plan value Line color need to change to Green and If Actual value is less than the Plan value ...
- 21
-5
votes
1
answer
442
views
Can I use a named range cell value as a formula in Conditional Formatting
I have an Excel where, for user ease, I'd like to put the conditional formatting (CF) formulas in the spreadsheet itself, and give the cell a name. Then use that single-cell range in the CF.
The ...
- 1,120
0
votes
0
answers
155
views
Excel VBA macro is unintentionally changing my conditional formatting
I have a couple of macros for my spreadsheet and it seems the main one I run keeps changing the "Applies to" rule of my conditional formatting.
The macro is extremely simple, it just uses ...
0
votes
1
answer
104
views
How to auto assign a number to a row based on conditional formatting
I have a contact form where I want to assign a priority contact based on how many days it has been since the last contact.
In the example image I have the the conditional formatting in Column E which ...
- 181