I have this formula that works right on the cell selected but sometimes the cell next to it can be greater or equal to it... so that one would need to be highlighted as well but it doesn't.... =$C$4>=$D$4:$G$4


anyone know what I'm missing???

I now have 2007 excel and I had a nother conditional formating on another sheet and it doesn't work right, it did before... I'm supposed to highlight a row only if Yes is selected... and its only selecting that cell. Think both problems are related.