change a row text colour when a cell = value x

[Princy557]

Hi,

I would like to make a row (5 columns) to change to text color light gray. the action to be triggered by the 5 column value.

I already have col2 and col3 triggering the col5 to show as 'COMPLETE'. From that saying complete I also want the row-col1 to 5 to all change to light gray text?

How do I set that up, please?

Regards
Princy557

[SuperTech]

Please share the file and the condition for which you want to implement this action.

If your file is private, please send it to forum[at]softmaker.com with the link of this post.

[ananclipping]

Hi,

I would like to make a row (5 columns) to change to text color light gray. the action to be triggered by the 5 column value.

I already have col2 and col3 triggering the col5 to show as 'COMPLETE'. From that saying complete I also want the row-col1 to 5 to all change to light gray text?

How do I set that up, please?

Regards
Princy557

You can achieve this by using conditional formatting or custom scripts. For example, if you're using a framework like HTML and JavaScript, you can add a condition to check the value of col5. If it equals "COMPLETE," apply a CSS class to change the text color to light gray. Here’s a simple example:

javascript
Copy code
if (col5 === 'COMPLETE') {
document.querySelectorAll('.row').forEach(cell => {
cell.style.color = 'lightgray';
});
}
This should change the text color for all columns in the row when col5 displays "COMPLETE."

[Princy557]

Sorry for my absence, Christmas, New Year and family have been a priority.
Seasons greetings to you all.
I need another two days to get back on track with this problem.

Note: After Supertech asked I uploaded a small file, which I can't see on this forum. I'll re-upload soon.


Regards
Princy557