All Questions
Tagged with excel conditional-formatting
1,939
questions
0
votes
0
answers
30
views
Average of Conditionally Formatted cells by color
I have a dataset (below) in excel that is conditionally formatted using the excel pre-set GREEN-YELLOW-RED color scale. What I want to do is find the average based by color of cell...and the whole ...
0
votes
1
answer
62
views
Is there something wrong with this function to exclude entries in a conditional format in Excel?
I am trying to format a column to display duplicate entries, but I would like to exclude #N/A as that is what shows up when there is no data to display that is meaningful. I have a memo from an order ...
1
vote
1
answer
52
views
Excel Conditional Formatting using Index Match and Wildcards
I have a spreadsheet that reviews payment file names and values that needs formatting to highlight specific lines where the file exceeds a set value based of the file name & its storage location, ...
0
votes
3
answers
69
views
IF AND and conditional formatting question
I am trying to find the right formula for the below situation. Not sure if conditional formatting is the answer or a formula or a combination. I have reviewed guidance for how to use IF and IFS as ...
0
votes
2
answers
31
views
Hide Data Bar, if value is outside a certain range?
I'm trying to do some tricky conditional formatting.
Basically, I want a databar to show if the cell value is between 0 and 1, but if the value is greater than 1, then the databar should not be ...
0
votes
0
answers
26
views
How to conditionally format multiple cells to ignore the formula and format only based on the value in Excel?
I have a worksheet with a large number of formulas in it. Each formula references another cell in another worksheet (ex. =HARASH!$U$16). I want to conditionally format each cell based on the cell ...
1
vote
2
answers
35
views
How to apply conditional formatting to cell depending on data in a known column and the same row as the cell being formatted?
I have a matrix of cells with labels in the upper row (in this example, Stores) and leftmost column (Products). I have a couple of dropdowns that I can use to select a value from these labels (...
0
votes
1
answer
22
views
How to Apply Conditional Formatting to Font Color, Interior Cell Color, and Borders in Excel Using VBA?
I'm trying to use VBA to apply conditional formatting to some cells in Excel. I want to change the font color, interior cell fill color, and also the borders based on a formula condition.
I've ...
0
votes
2
answers
86
views
Conditional formatting with OR function, using Row() and Dynamic column number
The column_num is dynamically fetched. Based on that i need to conditional format the cell which mathch the value "yes" or "true". The conditional formatting is not working when it ...
1
vote
1
answer
22
views
Conditional Formatting to highlight current date on calendar
I'm trying to format my excel calendar to highlight the current date but I'm struggling to find a way around it because my calendar is put together using a sequence formula.
Formula applied in cell B4:...
-2
votes
6
answers
102
views
Conditional format cells in 1 column not containing specific words x & y, blanks excluded
I'm needing to conditional format all cells in one column that don't contain the exact wording "Recyclable" and "Non-Recyclable" with all the blanks remaining untouched. This is to ...
0
votes
1
answer
61
views
How to remove small tilde and other special characters from excel? [closed]
I am learning excel from scratch, and I have a dataset of around 7000 entries. Some of these entries have texts such as:
This obviously is not clean data, and I wish to highlight it. I tried using ...
0
votes
2
answers
62
views
Minimum highlight formula not working for Conditional formatting in excel
I'm essentially trying to create a conditional formula that highlights the minimum value per row in a range. I tried a lot of formulas, and the simpler formula like =MIN($E4:$BF4)=E4 does not work for ...
0
votes
1
answer
63
views
How to add a min/max value in conditional formatting using xlsxwriter for python?
I am trying to create a shmoo plot with conditional formatting where the formatting rule knows the minimum value and does not mark the minimum value in the table with the minimum color, instead it ...
0
votes
0
answers
41
views
How to use conditional formatting to highlight occurrences across two columns
I am trying to count the number of products per shipment, each occurrence of the same vessel name on the same date means a new product. So, in the example below, on the 10/06, Vessel A delivered three ...