I want to set the background colour of 3 adjacent cells based upon a formula.

I've followed the guidelines etc.. and have selected the range of cells, but when the conditions of the formula are met, the background colour of only the first cell in the range is set to the stipulated colour, the other 2 remain white (no fill colour).

Has anyone else seen this problem? And is there a fix?

Thank kindly.

Screenshot of the problem

  • Please describe the columns (with their names) of the image and also column B (absent from the attached image)
    – Daniele
    Sep 5, 2022 at 15:37

1 Answer 1


You have to place a $ sign to lock your column reference, so the custom formula must be something like this:


Note that we don't know nothing about column B

c f

  • Thanks kindly, problem solved, much appreciated
    – James
    Sep 6, 2022 at 6:59

Your Answer

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

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