Conditional formatting Topic is solved

[acroporax]

Hi all,

Code: Select all

function browseConditionalFormatting() {
    $('[data-nu-column="1"]').each(function (index) {
        var v = $(this).html();
        var color = String(v) == "TOPLAM" ? 'yellow' : '';
        $(this).css("background-color", color);
    });
}

This code working for 1 column, but i want change to color data-nu-column="2 and data-nu-column="1" together. But conditinal if must look only data-nu-column="1" How to make?

[kev1n]

Hi,

Do you mean that column 1 + 2 should get the bg color yellow if the value in column 1 is TOPLAM?

[acroporax]

Hi,

Do you mean that column 1 + 2 should get the bg color yellow if the value in column 1 is TOPLAM?

Correct.

[kev1n]

Give this a try:

Code: Select all

function browseConditionalFormatting() {
    $('[data-nu-column="1"]').each(function (index) {
        let v = $(this).html();
        let color = String(v) == "TOPLAM" ? 'yellow' : '';
	let bg = {"background-color": color};
        $(this).css(bg).next().css(bg);
    });
}

[acroporax]

Give this a try:

Code: Select all

function browseConditionalFormatting() {
    $('[data-nu-column="1"]').each(function (index) {
        let v = $(this).html();
        let color = String(v) == "TOPLAM" ? 'yellow' : '';
	let bg = {"background-color": color};
        $(this).css(bg).next().css(bg);
    });
}

Thank you so much,

[acroporax]

Hi Again,

I am using the above code, thanks a lot. But how can i column1 < column2 result Red..

[kev1n]

Do column 1 + 2 contain numeric values?
If the value in column 1 is smaller than the one in column 2, column 1 (or 2?) should be red?
Or is the logic different?

[acroporax]

Example;
column1 = "Customer Name"
column2 = "2022 sales of year"
column3 = "2023 Sales of year"

column1 = "Michele"
column2 = "10 $"
column3 = "20 $"


if (column3 <column2)
{ column1.background=red}

[kev1n]

As long as there are no negative numbers, this should do the job:

Code: Select all

$("[data-nu-column='1']").each(function(index) {

	const c1Value = this.innerText.justNumbers();
	const c2Value = this.nextSibling.innerText.justNumbers();	
	
	const color = c2Value < c1Value ? 'red' : '';
	const bg = {"background-color": color};
	$(this.previousSibling).css(bg);

});

[acroporax]

it's working well, thanks..