3,050 questions
0
votes
1
answer
66
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
80
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
92
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
60
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
100
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
84
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 ...
- 587
0
votes
0
answers
41
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
77
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
53
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(...
- 154
2
votes
1
answer
98
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
62
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
47
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
33
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
97
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