Most voted "conditional-formatting" questions
10 questions
Sort by count of
-
15
votes4
answers3950
viewsWhen to use ternary condition?
I particularly like the use of ternary condition, but I see many developers saying no, there is even a rule in Checkstyle when validating your code that encourages you not to use. See the example…
condition encoding-style conditional-formattingasked 10 years, 4 months ago Philippe Gioseffi 3,202 -
3
votes1
answer510
viewsConditional formatting error if document opened in Microsoft Office
When applying conditional formatting to a spreadsheet xlsx generated with the Phpexcel, the same works smoothly when the document is opened in Libreoffice: $objConditional = new…
-
2
votes1
answer4307
viewsApply icon depending on the text value in the cell
Assuming as example the column E, the value of which Sim or the value Não, I am trying to create a conditional formatting that applies an arrow depending on the text present in the cell itself: Sim…
conditional-formattingasked 9 years, 1 month ago Zuul 35,190 -
1
votes2
answers1586
viewsApply conditional formatting individually to each sheet line
I have a spreadsheet with dates and cities. I need to highlight (paint of some color) the cities that are repeated on the same date I can apply conditional formatting for this, but doing one line at…
-
1
votes3
answers193
viewsConditional formatting on line R
I wanted to replace the empty fields (Nas) in 'number of turns' with the variable (VAR1 - 3) that is filled. I plan to do it in a larger date.frame. As you suggest?…
-
1
votes1
answer45
viewsMark the highest and lowest value of a column with kableExtra in R
I am building a report in Rmarkdown and need to create a table with the data table below: MEDIA <- data.frame(Questões = c("Questão 43", "Questão 44", "Questão 45", "Questão 46", "Questão 52",…
-
0
votes1
answer522
viewsZebra pattern in libreoffice
In Libreoffice Calc, I want to separate in a list of artists and titles, the artists by means of a different color. That’s the result I wish: As you can see, I wish in column C a formula to indicate…
-
0
votes0
answers135
viewsConditional formatting between columns in VBA
I need help with conditional formatting. I have a VBA code to compare two columns, one that is in a hidden tab, contains a series of systems that we use in the company and another one contains a…
-
0
votes1
answer157
viewsConditional completion
I need a help with VBA. My question is this:: I need cell "B" and "C" to receive a specific value when I type a value into cell "A": For example: When I type the value "1" in cell "A", cell "B"…
-
-1
votes1
answer42
viewsHow to make a "hierarchical conditional formatting" in Excel 2010?
i need to program a "hierarchical conditional formatting" in Excel 2010, based on two entries: the cell format on the left and whether the value belongs to a given range or not. To understand better…