However, by using your own formula, you have more flexibility and control.
When a new value is entered, the highlighting is immediately updated.
The reference to C5 isrelativeand changes as the formula is evaluated for each cell in the range.
The reference to cell J6 is “locked” as anabsolute reference($J$6).
