Conditional formatting "between"
Solved
Htfrison
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I'm working on a complex table that fills itself based on a chosen element.
Let me explain:
When I select the main element, some cells fill in and provide me with a low threshold and a high threshold. In the cell below, I need to indicate the actual value.
I would like the conditional formatting to highlight this cell in green or red depending on whether the value is within or outside the range.
If the cells that auto-fill with the high/low thresholds were not the result of a formula, this would be very simple; however, in this case, it seems to compare a value (the one I enter) with the text of the formula in the high/low threshold cells, at least that's what I think. Because if I delete the formulas and manually enter the numbers in the cells, the formatting works.
So my question is, how can I ensure that the conditional formatting takes into account the result of a formula rather than the formula itself?
Configuration: Windows / Chrome 61.0.3163.100
I'm working on a complex table that fills itself based on a chosen element.
Let me explain:
When I select the main element, some cells fill in and provide me with a low threshold and a high threshold. In the cell below, I need to indicate the actual value.
I would like the conditional formatting to highlight this cell in green or red depending on whether the value is within or outside the range.
If the cells that auto-fill with the high/low thresholds were not the result of a formula, this would be very simple; however, in this case, it seems to compare a value (the one I enter) with the text of the formula in the high/low threshold cells, at least that's what I think. Because if I delete the formulas and manually enter the numbers in the cells, the formatting works.
So my question is, how can I ensure that the conditional formatting takes into account the result of a formula rather than the formula itself?
Configuration: Windows / Chrome 61.0.3163.100
2 réponses
Hello
there's no reason why it should work with the keyboard and not with the formula, unless your formulas return text instead of numerical values
What are these formulas then?
And what do the cells they use contain?
first, to check your data, in the cells with formulas, write:
=(full formula)*1
or check if, by formatting in cell format / alignment / horizontal / standard
if the result is aligned to the right
best regards l
--
The quality of the response mainly depends on the clarity of the question, thank you!
there's no reason why it should work with the keyboard and not with the formula, unless your formulas return text instead of numerical values
What are these formulas then?
And what do the cells they use contain?
first, to check your data, in the cells with formulas, write:
=(full formula)*1
or check if, by formatting in cell format / alignment / horizontal / standard
if the result is aligned to the right
best regards l
--
The quality of the response mainly depends on the clarity of the question, thank you!