A simple example to illustrate ..

Suppose you want to CF entire rows based on the values in col B, say format
with brown fill for values exceeding 10

Select the entire sheet (A1 active), then apply the CF using
Formula Is: =$B110
Format Brown fill
Ok out

The key in the CF formula is to lock it to point to col B via using the "$"

The above will colour entire rows where col B contains numbers exceeding 10.
Test it out and see for yourself by inputting a couple of numbers down in B1,
B2, B3 etc.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Montu" wrote:
I got advice from this forum to change color of entire row by use conditional
format function. The advice is that "at first select entire row, then use
condinoal format". I have follow the advice but don't get result or it's not
change color of entire row, only conditional format cell address is changing
the color. If some one write me clearly about the formula or format, I shall
be very thank full to him or her.