Aug 19 2024 05:37 AM
Hello !
I am trying to get a cell to highlight if it is greater than a certain number only if the number in the corresponding row is equal to a certain number.
in other words:
Highlight the cell in column F if it is greater than 4 AND the value in column C equals 99 (on the corresponding row)
Highlight the cell in column F if it is greater than 10 AND the value in column C equals 17 (on corresponding row)
etc.... I am aware I will have to do a few different "rules" to get each set of numbers.
I really appreciate any help!!!
Aug 19 2024 05:47 AM - edited Aug 19 2024 06:38 AM
@Shannon430 For this, you will need to choose Conditional Formatting > New Rule > Use a formula...
The formula should be something like =AND($C5=99,$F5>4). The $ in front of C means that it will always look at column C. The row reference (5), should match the starting row that you have in the "Applies to" field. This means that it will apply to the current row. For example, if you set the Applies To to a range of cells in F, like $F$5:$F$100, and the formula is =AND($C5=99,$F5>4), the formula will look at the cells in C and F together on each row, starting with row 5.
It's important to understand how the references work in a formula in Conditional Formatting. A simple example is =A1>100 with an "Applies To" range of $A$1:$B$5. Since the formula refers to A1 (no dollar signs), and the range starts in A1, then the formula would be evaluated for each cell in the range as if you were saying "if my value is greater than 100". If the formula was =$A1>100, it would be like saying "if the value in A on my row is greater than 100". If the formula was =$A$1>100, it would be looking at the value in A1 for all the cells in the range.