Conditional Format or Visual Basic Code

[squeakums]

I'm trying to write some sort of code to color a cells in (column A) based on these parameters - these are grouped by number. if any number group of numbers in column A have no real number assigned in column B (such as 0 or #n/a) then column that number in column A. If column B has a real number such as that 11965; then leave all of the numbers in column A uncolored. For example those in red below, but I want it to fill a color instead.

Conditional format or Visual basic code - how's it written?

Column A Column B
36 11965
36 0
36 #n/a
36 0
38 #n/a
38 0
38 0
40 112
40 0
40 #n/a
40 0
14 0
14 #n/a
14 #n/a
14 0

 

[DanteAmor]

- Select the cells you want to format. eg A1:A15
- On the Home tab, in the Styles group, click Conditional formatting > New Rule…
- In the New Formatting Rule window, select Use a formula to determine which cells to format.
- Enter the formula in the corresponding box.

=COUNTIFS($A:A,A1,$B:B,">0")=0

- Click the Format… button to choose your custom format.
- click the OK button.
- click the OK button to save the rule

 

[squeakums]

Fabulosa Works

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.