VBA check list?

[sirspams]

"Hi,

I am trying to write a script that will check specific columns and ensure it contains

two cells with *specific text A* AND two more cells with *specific text B* AND a cell with *specific text C* AND a cell with *specific text D*.

If all that is in the column, then set that columns cell 3 background colour grey, however if even one of the specific texts are missing then set that columns cell 3 background to red.

 

[6StringJazzer]

This can be done with a single conditional formatting rule. Do you require VBA?

This example assumes the first column to format is column A. I do not understand what you mean by cell 3. Do you mean the cell in row 3?

Select row 3 of the columns you need to format.
Set the background color of row 3 to red, as a default.
Add a conditional formatting rule using a formula, applying grey formatting:

=AND(COUNTIF(A:A,"specific text A")=2, COUNTIF(A:A,"specific text B")=2, COUNTIF(A:A,"specific text C")=1, COUNTIF(A:A,"specific text D")=1)

If the first column to format is not column A, change A:A to the appropriate column.

 

[sirspams]

Hi 6StringJazzer

Thank you so much for the reply, some of this is helpful.
I was hoping for it in VBA as I have multiple colomns and multiple sheets to put this through.
I also feel being able to use interior.colorindex much nicer as in the long run it will involve multiple colours depending on many factors
And yes I do mean the 3rd cell down in each coloumn (coloumns C through AC)
With VBA code for this "basic" task I feel confident in modifying it to fit my specific needs.

(I say "basic" task but for myself it certainly isn't)

Cheers