Conditional Formatting in one column using data in two columns
In I2, you should be able to set the condition to:
Formula Is, =AND(H2=10,I2=0.2)
You can copy that cell's formatting to other cells in the same column.
--Bruce
"Renee" wrote:
I need to say if Column H cell = 10 and Column I cell is =0.2 then
Highlight Column I yellow.
I can't seem to get the right formula in my conditional formatting
requirements.
Any help you can offer would be greatly appreciated.
|