View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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.