Conditional formatting is a technique used by Microsoft Excel. Cells can be configured to show different formatting, such as colours or symbols according to the value in the cell. For example, negative values could have a red fill colour for the cell.
0
votes
0answers
15 views
Finding Cell Location in Excel with Apache POI
I have cell objects that I am writing to from an array of information. What I am trying to do is have it that the program will handle any size of array so the cells are being filled in dynamically i ...
0
votes
1answer
13 views
Referencing current cell for compare across sheets
I'm trying to compare binary values between two sheets in Excel. Here's a quick snapshot of what the data might look like for row 1, columns A-D on the two sheets.
A B C D
1 1 1 1 1 ...
0
votes
2answers
14 views
excel using if condition to copy either one cell or another
im creating a list of sorts where i have two columns one with an expected value the next with an actual value based on info taken from a dropdown box so three possible variables. i would like a third ...
1
vote
1answer
30 views
Excel Alternate Row
I have created a conditional format rule for alternate row style. It changes the cell fill for the cell to some color. The problem i have with this is that It override any other formatting that is ...
-1
votes
0answers
67 views
Excel macro that automatically highlights which values in a range are not ignored in formula/calculation with conditions
I need a excel macro that automatically highlights which values in a range are not ignored in a sumproduct formula with conditions or an if formula; for example in range A1:C1 if only values in cells ...
-1
votes
1answer
30 views
Bold conditional formatting script for Google Spreadsheets
What I want to do is essentially what this user wanted to do here:
I need a script that formats the cells in column A bold, but only the cells that contain the word 'Hello'.
However I have no ...
google-apps-script
0
votes
0answers
39 views
Field Conditionally Required in Sharepoint Designer 2007
I'm having a problem trying to make 2 fields visible and required only when a dropdown is "Customer"
And an opposite condition where one field is required\visible when
fieldX = Foo,
and
...
0
votes
1answer
42 views
Conditional Formatting with Flexcel
I want to modify the colors of some cells in an already filled Excel spreadsheet using the method:
FlexCel.Adapter.XlsFile.SetCellFormat(int row1, int col1, int row2, int col2, int XF);
The ...
0
votes
0answers
45 views
Apache POI 3.9 conditional formatting (string value)
I have the following code set up in my servlet to format a column based
on a string value but, I get an error when trying to compile (org.apache.poi.ss.formula.FormulaParseException: Specified named ...
0
votes
1answer
66 views
Apache POI - Generating conditional formatting that refers to other cells
I'm generating an XSSF spreadsheet in Java using Apache POI. What I'm trying to do is generate a conditional formatting formula that's similar to "if the value in cell $A2="X", turn $C2 green", and ...
-1
votes
4answers
180 views
Excel Conditional Formatting (IF not empty)
How do I do conditional formatting if cell is not Blank, then fill the cell with grey color? I tried to do not equal, but it didn't work. Thanks!
EDIT: Sorry for the delayed response. But I am using ...
0
votes
3answers
81 views
Excel: Conditional formatting for clusters of values
In an EXCEL 2010 spreadsheet, how can I create alternating fill color for clustered cell values, changing when a new value cluster is reached?
Assume column A contains the following values:
VALUE
...
0
votes
2answers
127 views
XLS - Conditional Formatting - Java POI Example
:)
Finally after the research I found the solution to my problem, which is not yet satisfied
I would like to use conditional formatting to show a line with a yellow color if column B and C to the ...
4
votes
1answer
153 views
Conditionally formatting text strings from Excel using python
I would like to format a spreadsheet (xls or xlsx) so that any cells containing a word or ending with a certain string are formatted by filling the background with a specific color.
For example, if ...
0
votes
2answers
33 views
Formula that returns true or false when 1 value from a list of values meets a condition
I am looking for a formula that returns true or false when 1 value from a list of values meets a condition.
List:
100
200
300
400
=If(List>350;true;false)
The last value of the list is bigger ...
