Conditional formatting based on formula addressing current row in LibreOffice Calc
I have a column of cells in LibreOffice Calc with conditional formatting to apply a style to those cells.
The conditional formatting is programmed to format the cell if the following formula is true:
AND(B106=0,C106=0)
The trick is that instead of always evaluating this formula for row #106, I would like to evaluate the formula for the current row.
For example, in cell A1, I would like the conditional formula to be
AND(B1=0,C1=0)
And in cell A2, I would like the conditional formula to be
AND(B2=0,C2=0)
What I'm looking for is to program the entire column with a conditional formula like
AND(BCURRENTROW()=0,CCURRENTROW()=0)
but obviously that syntax is incorrect.
How can I accomplish this?
A conditional formatting based on a formula has two settings that determines where and how it applies.
First is the Cell Range to which it applies to. If this is
Range : A1:A1048576
then it applies to the whole column A.
Second is the formula itself. Precisely whether cell ranges in that formula are relative or absolute or mixed. As in all other formulas, a relative cell reference is A1 for example. A absolute cell reference is $A$1 for example. And mixed cell references could be $A1, where column A is absolute but row is relative, or A$1, where column is relative but row 1 is absolute.
So a conditional formatting applied to range A1:A1048576 and having formula AND($B1=0,$C1=0) should fulfilling your requirement. As you see the formula always gets columns B and C (absolute) but gets the row in which it is actually calculated (relative).
Example:
- Minimum Row Count condition based on values of all columns in pandas DataFrame
- Adding numbers in Excel, based on a condition
- Detect dashboard of WooCommerce "my account" pages
- How can I use INDEX and MATCH along with conditions to filter data into different tables?
- Filtering JSON array based on conditional value in python
- Split string representing a comparison condition into its three parts
- Good C-coding style for multiple lines if conditions
- NotNull Boolean value If else with Stream API
- v-show alternative for Svelte
- Using or in if statement (Python)
- Chain several WHEN conditions in a scalable way in PySpark
- Building a hash in a conditional way
- How do you make a conditional test if an element exists in Cypress?
- How to implement Do - While Loop including If Else Statement in this case?
- Condition Using Controller in Code Igniter
- How to enter information in one cell based on text in another cell
- What are the differences between if-else and else-if?
- Can't you use `,` operator to define a variable in a while loop's expression in C?
- Avoiding nested if else statement ladder in Python
- Using Nested Conditional Expressions
- Can you use if/else conditions in CSS?
- (Swift) Initializer for conditional binding must have Optional type, not 'AVAudioInputNode'
- Microsoft question regarding IIf statement or a better solution
- Amazon S3 conditional put object
- How can I change certain values in a column based on multiple conditions, leaving others as they are if the conditions aren't met?
- C++ All Int are valid for the if statement | if(choice == 1)
- Laravel Checking If a Record Exists
- Print largest & second largest number from three variables entered by the user by conditional statement
- numpy.where build conditional filter in python
- In php using @ instead of isset