change color of entire row by use conditional format

M

Montu

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.
 
S

Stephen

Montu said:
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.

You don't say what condition you want to cause the colour change. However, I
suspect you need to use absolute addressing in your formula, rather than
relative.

As an example, suppose you want to change the colour of the whole of row 1
when the value in A1 is greater than 10.
Select row 1 and open conditional formatting.
Change "Cell Value Is" to "Formula Is" and the type in the formula:
=($A$1>10)
Select the conditional format colour and click OK.
 
M

Max

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: =$B1>10
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top