Help me, conditional formatting.

[iRasim]

I want to know if in column numbers A, C ,E less than number column G make that cell red. For example C2 (1) less than g2 (2,5).

 

[tomas]

is this you wanted?

 

[iRasim]

Thanks you a lot. That`s great.That`s what I want. Could you say how i can find explanation of the formula that you gave ?

 

[tomas]

You are welcome
=AND(NOT(ISBLANK(A2)),A2<$G2)

So ConF. is applied if cell returns TRUE.
Function And returns TRUE if all conditions are TRUE
In this case we have to conditions:
1. NOT(ISBLANK(A2)) -- this returns TRUE if cell is not empty ( if this condition wasnt applied empty cells would be formatted as well )
2. A2<$G2 -- this one should be fairly obvious

if anything unclear just let me know

 

[iRasim]

Thank you so much.

 

[Khalid NGO]

Hi,
=AND(NOT(ISBLANK(A2)),A2<$G2)

Can be more simplified:
=AND(A2<>"",A2<$G2)

Regards,