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.
1
vote
0answers
31 views
conditional formatting for newly added rows
Ok, I really have no business working in spreadsheets or any data entry program for that matter. So basically what I am saying is I have no idea how to use much of the formula and script/language ...
1
vote
0answers
77 views
Conditional formatting with POI libraries
I am facing some issues with POI conditional formatting. I am not exactly getting what POI is doing here.
I am setting background colour formatting rule for cell value which has value more than 70.I ...
1
vote
0answers
545 views
Excel conditional formatting with VBA and user designed function
Overall my goal is to create a VBA macro that will go through a worksheet and apply a conditional formatting formula using a user designed function. The worksheet is broken up into various groups ...
1
vote
0answers
74 views
Is there a way to create 2-color and 3-color scale conditional formats in PHPExcel?
I'm trying to apply 2-color scale and 3-color scale conditional formats to an Excel sheet that I am creating with PHPExcel. Looking at the documentation, it appears that PHPExcel doesn't support ...
1
vote
0answers
761 views
Jqgrid how to retain cellattr conditional formatting while the datatype is local (or loadonce: true)?
I have a jqgrid load a large amount of rows (in 1000s) with loadonce:true option. The user will operate on the data locally after the jqgrid is loaded. I also have a conditional formating on one of ...
1
vote
0answers
319 views
Conflicting Gridview DataBinds for two different tasks
I have had an Export to Excel functionality built into one page. Thanks to help from here, I just added in functionality to conditionally format a certain cell (which is included in the Export to ...
0
votes
0answers
19 views
Need help scripting a mass conditional formatting
I am running a NFL win/loss pick em and using Google Docs, but the processing of the data is cumbersome so I am working out some scripts to make it flow better. I have it set to automatically count ...
0
votes
0answers
13 views
Outlook Conditional Formatting Disappearing
We are having a strange problem where outlook periodically (there doesn't seem to be a logical trigger) deletes the conditional formatting I have set up. It's happened on four different computers a ...
0
votes
0answers
12 views
Using Conditional Formatting With Words
I'm using a Spreadsheet in Google Docs, and trying to find a script that will let me do a kind of conditional formatting that Google will now allow on it's own.
If any cell in E has "Paid" in it I ...
0
votes
0answers
94 views
Conditional formatting based cell change
I want to create a formula based on modification of the cell.
I have certain range of numeric cells. Conditions should be:
when value of a cell became more than current value - highlight with one ...
0
votes
0answers
43 views
Conditional formatting for a cell that contains a single numeric text character
How do I set conditional formatting for a cell that contains a single digit as text, not as a number!
There seems to be a maximum number of conditions which can be assigned to a cell. And, ...
0
votes
0answers
19 views
Adding conditional formatting to an existing web
And thanks in advance
At work we have a program that manages connections. This has a web interface that is basically just a table listing the connections, whether they are enabled, whether it is ...
0
votes
0answers
37 views
Condition Oriented Job
I want to append part of a line from file2 into file1...
I have 2 file named,
file1:
recev: Na Sod B 1 H-atom: H Hydrogen D 2
accept: F Fluorin B 91 R-A = 12.44
another: Zn Zinc x 000
accept: ...
0
votes
0answers
20 views
Conditional Formating On Multiple cells in Different Sheet
I have a group of cells (B3:M16) on sheet Calc-Chart, and there are only 6 values these cells can have (QB, RB, WR, TE, K, DST). I am trying to conditionally format a different sheet but the same ...
google-apps-script
0
votes
0answers
188 views
How to add Conditional Formatting to the data table IN a Pivot Chart
I have a pivot chart that I need the "% of Service SLA" in the data table, which is part of the graph, formatted with conditional formating. The picture displays me making due with using a drawing ...
