View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aspiremind Aspiremind is offline
external usenet poster
 
Posts: 2
Default Conditional Formatting - Reference to multiple column

I need to highlight certain cells in column G for values less than 3 but only
do that when the corresponding row (cell value) in coumn E is greater than 3.

For example,

If G40 < 3 but E40 <=3 then G40 won't be highlighted
If G40 < 3 but E40 3 then G40 will be highlighted
If G40 3 then no action will be taken

I'm using Excel 2007.