View Single Post
  #1   Report Post  
sweetsue516
 
Posts: n/a
Default Conditional Formatting

I two rows of data, some numbers and some are N/A.

I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".

Is there a formula I can use to get around this?

Thank you