I am working on a spreadsheet which has different values in column B (values are 3, 4, A, B, C). I am trying to create a conditional format that will highlight column E.
Each item in column B has a value that needs to be met. Example A requires at least 160, C requires at least 32
I would like column E to be highlighted red if the number in column E is less than the requirement (example 160) and green if greater than or equal to requirement.
This sounds really simple, but I am struggling!
Thanks in advance!
Each item in column B has a value that needs to be met. Example A requires at least 160, C requires at least 32
I would like column E to be highlighted red if the number in column E is less than the requirement (example 160) and green if greater than or equal to requirement.
This sounds really simple, but I am struggling!
Thanks in advance!