I'm trying to set up a semi-dynamic spreadsheet for our shop's fire extinguisher program. I'm pretty close to being done with it, except the conditional formatting is, naturally, giving me some problems.
As per usual, here's a screenshot showing what I have now (shown at the top, accompanied by the formulas in effect), and also showing what I'm trying to get through conditional formatting (shown at the bottom.
I want the users to be able to groups of fire extinguishers without any unnecessary formatting, on their part.
The red shading will actually be white, when all is said and done. I went with red merely to add contrast.
Note: disregard error in the formulas shown. I just noticed it after I already uploaded the picture, though correcting said error made no difference.
Here's the corrected formula:
=NOT(ISERROR(FIND("Extinguishers",A4:C6)))
(yeah, I forgot that the formula is the same for both rules.../facepalm)
Anyway, the idea is that each group of extinguishers will have its own heading, and each heading will include the word "extinguisher," which is the condition that shades the cells on the left in black, and will shade the cells to the right of them in white.
So, what am I doing wrong with the formulas?
(Mind you, I purposefully went with a formula for filling in the cells on the left because the content-based rule was giving me the same result, and I don't know what can done to fix that.)
As per usual, here's a screenshot showing what I have now (shown at the top, accompanied by the formulas in effect), and also showing what I'm trying to get through conditional formatting (shown at the bottom.
I want the users to be able to groups of fire extinguishers without any unnecessary formatting, on their part.
The red shading will actually be white, when all is said and done. I went with red merely to add contrast.
Note: disregard error in the formulas shown. I just noticed it after I already uploaded the picture, though correcting said error made no difference.
Here's the corrected formula:
=NOT(ISERROR(FIND("Extinguishers",A4:C6)))
(yeah, I forgot that the formula is the same for both rules.../facepalm)
Anyway, the idea is that each group of extinguishers will have its own heading, and each heading will include the word "extinguisher," which is the condition that shades the cells on the left in black, and will shade the cells to the right of them in white.
So, what am I doing wrong with the formulas?
(Mind you, I purposefully went with a formula for filling in the cells on the left because the content-based rule was giving me the same result, and I don't know what can done to fix that.)
