I am trying to create a cell with conditional formatting, however, the conditions depend on the value of another cell.
Example:
A1: Type of Exposure (Exterior or Interior)
A2: Equation
For exposure type 'Exterior' the value of A2 must be lower or equal to 10. If true, cell turns green, if false red.
However, if exposure type changes to 'Interior', the new condition states that the value of A2 must be lower or equal to 5.
Is there a way to insert a 'If' statement into a conditional formatting rule, or to do something equivalent?
Thanks!
Bookmarks