Conditional formatting with VBA for multiple conditions

Question

I have a spreadsheet with a number of sheets used by users. They are asked to input information in some of the sheets and the first Sheet is a summary of results. There are four conditions, if selected, lead to a pens down scenario where no further work needs to take place. Let's say if, Cells A1, B1, and C1 = "No", or if Col 1 in Sheet 2 contains "No", no further work needs to be done in Cells D12:K39, or some such range.

I thought running with conditional formatting may work, but the results are not great. Something like: =$A$1="No", and so on for the other conditions, then I colour out the selection range

I'm very new to VBA, but see this as way to get my results. I have no idea how to structure the above condition.

Answer 1

Don't give up on conditional formatting just yet.

1. Select Cells D12:K39
2. Go to Conditional Formatting > Use a formula to determine which cells to format
3. Enter the formula =OR(COUNTIF($A$1:$C$1,"No")=3,COUNTIF(Sheet2!$A:$A,"No")>0)
4. Change the formatting as needed