1

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

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

1 Answer 1

Reset to default
0

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

=$H2*$B$9-$B$12<=0

Note that we don't know nothing about column B

c f

Improve this answer
1
  • Thanks kindly, problem solved, much appreciated
    – James
    Commented Sep 6, 2022 at 6:59

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.