I am trying to create a conditional format that will highlight cells across 2 separate columns based on data in both columns:

enter image description here

So I need to highlight all cells in column A that is greater than 0 AND the cells in column b that contain the text green. Both conditions must be met, i.e.

cell b8 contains green, cell a8 contains 0 = no highlight in either column cell b4 contains green, cell a4 contains 7 = highlight cell a4 and b4

I have worked out how to count the data as shown in cell D5 by using countifs, however if I enter that as a custom formula in conditional formatting it does not highlight the required cells.

1 Answer 1




  • Thanks very much, did exactly as required
    – good karma
    Jun 23, 2020 at 12:12
  • That's great. If you wish, you could accept the answer.
    – Tedinoz
    Jun 24, 2020 at 1:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.