Highlight cell in column F if it is greater then 4 AND value in column C equals 99 (on cor row
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!!!
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!!! Read More