SomeManager
New Member
- Joined
- Apr 2, 2023
- Messages
- 4
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
I guess this is my last hope of finishing my project.
I guess it could be out of topic , but google sheets has the same as excel, right?
Basically, I need some kinda automatic formula which colors the row in red colour based on 2 conditions:
1. specific cell value is true
2. row contain cell/cells with specific text
Here are screenshots:
As you can see we have 2 employees with left cell ''RO'' values ''True'' and ''False''. I want that if the value of ''RO'' cell is ''True'' and this row contain any ''RO*''(RO*1-9*) inside to mark whole row in red color like this:
I have tried conditional formatting with IFS,INDIRECT,IFS+COUNTIF and it half-worked, by that I mean it did colour the entire row, but, when cells are being overwritten conditional formatting dissapears and our team need more sustainable solution to the problem. Before that we were colouring only 1 cell with red colour via conditional formatting using this formula: =AND(INDIRECT("R[0]C[-24]", FALSE)=TRUE,INDIRECT("R[0]C[0]", FALSE)>0) but as the company is growing we need more flexible solution, rather than load file with bunch of INDIRECTS which causes performance issues of the file.
In case you know the solution, please keep in mind we have 100 rows of that type of info as on screenshots, this one just tip of the iceberg.
Will be online on this forum for a few days in case some of you can help.
I guess this is my last hope of finishing my project.
I guess it could be out of topic , but google sheets has the same as excel, right?
Basically, I need some kinda automatic formula which colors the row in red colour based on 2 conditions:
1. specific cell value is true
2. row contain cell/cells with specific text
Here are screenshots:
As you can see we have 2 employees with left cell ''RO'' values ''True'' and ''False''. I want that if the value of ''RO'' cell is ''True'' and this row contain any ''RO*''(RO*1-9*) inside to mark whole row in red color like this:
I have tried conditional formatting with IFS,INDIRECT,IFS+COUNTIF and it half-worked, by that I mean it did colour the entire row, but, when cells are being overwritten conditional formatting dissapears and our team need more sustainable solution to the problem. Before that we were colouring only 1 cell with red colour via conditional formatting using this formula: =AND(INDIRECT("R[0]C[-24]", FALSE)=TRUE,INDIRECT("R[0]C[0]", FALSE)>0) but as the company is growing we need more flexible solution, rather than load file with bunch of INDIRECTS which causes performance issues of the file.
In case you know the solution, please keep in mind we have 100 rows of that type of info as on screenshots, this one just tip of the iceberg.
Will be online on this forum for a few days in case some of you can help.
