Conditional formatting (2002)

Topic

New Reply

I am applying conditional formatting to an entire column. Is there a way to apply conditional formatting to an entire row of information based on criteria in one column?

Reply | Quote

Replies

Welcome to the Lounge!

Yes, you can. Select the row, then select Format | Conditional Formatting…
From the dropdown list, select Formula Is.
In the box next to it, enter a formula such as this:

=($F1 > 100)

where F1 is the cell you want to test. (I have assumed row 1 for this example). Click Format to specify the formatting to be applied, then click OK twice. The $ before F means that this column is fixed; if you omit it, the formula will be adjusted for other cells.

Reply | Quote

Thanks for replying so quickly. I tried this but it did not work. I am sending the file that I am using. What I want to do is apply conditional formatting to column F to highlight what is behind schedule and have the formatting applied to the entire row.

Reply | Quote

In conditional formatting use Cell value is / equal to / Behind
and click ok.

If you want to be sure it works place it in a cell which has Behind in it.

To copy this to other cells (those you want in column F) click on the cell you placed the conditional formatting in, copy, then select the cells you wish the formatting to go into and select paste special / formats. That should do it.

yoyophil

Reply | Quote

In conditional formatting use Cell value is / equal to / Behind
and click ok.

If you want to be sure it works place it in a cell which has Behind in it.

To copy this to other cells (those you want in column F) click on the cell you placed the conditional formatting in, copy, then select the cells you wish the formatting to go into and select paste special / formats. That should do it.

yoyophil

Reply | Quote

YOu need to put parentheses around Behind.
Select A4:E28
Format – cond format
Formula is:

=($F4="Behind")

Steve

Reply | Quote

YOu need to put parentheses around Behind.
Select A4:E28
Format – cond format
Formula is:

=($F4="Behind")

Steve

Reply | Quote

Thanks for replying so quickly. I tried this but it did not work. I am sending the file that I am using. What I want to do is apply conditional formatting to column F to highlight what is behind schedule and have the formatting applied to the entire row.

Reply | Quote

Thanks for this method – I have been trying to figure out a way to do this for years (literally!), and this worked beautifully for me.

Michelle

Reply | Quote

Welcome to the Lounge!

Yes, you can. Select the row, then select Format | Conditional Formatting…
From the dropdown list, select Formula Is.
In the box next to it, enter a formula such as this:

=($F1 > 100)

where F1 is the cell you want to test. (I have assumed row 1 for this example). Click Format to specify the formatting to be applied, then click OK twice. The $ before F means that this column is fixed; if you omit it, the formula will be adjusted for other cells.

Reply | Quote