conditional formatting

[nevada15]

Hi,

A quick question on conditional formatting. I defined a conditional formatting on a cell. How can I copy and paste the conditional formatting on other cells.

Thanks,
nevada15

[berlan]

Copy the cell and Paste Specials (formats), or change the appliedrange for the CF.

[nevada15]

Oh, great! It worked now. Thanks!

nevada15

[Special-K]

The paintbrush icon is quicker.

[cbenner3017]

Hi all,

I have a column with values and I would like for conditional formatting to highlight just one cell with the lowest value
from the entire column of values. Could you please give me an idea of the formula to accomplish this? The column with
the values is pasted below here:
07:27
07:12
06:19
08:12
06:27
05:57
07:57
04:35
09:08
07:39
06:02
05:33
06:13
08:04
05:15
05:17
06:53
06:45
08:22

[2011winner]

use top bottom rule in conditional formatting and change bottom to 1

[cbenner3017]

Hi all, I have a row of cells that I would like to have the first cell in the row be colored based on the value of the last cell.
The value happens to be times (minutes:seconds)
I would like the first cell in the row to be colored red if the value of the last cell in the row is equal to or greater than 7:00
I would like the first cell in the row to be colored yellow if the value of the last cell in the row is less than 7:00
The row with the cells is below:
BRISTO A NOT GOOD Fast Track drive thru average 07:00
Any ideas?

[FDibbins]

Hi all, I have a row of cells that I would like to have the first cell in the row be colored based on the value of the last cell.
The value happens to be times (minutes:seconds)
I would like the first cell in the row to be colored red if the value of the last cell in the row is equal to or greater than 7:00
I would like the first cell in the row to be colored yellow if the value of the last cell in the row is less than 7:00
The row with the cells is below:
BRISTO A NOT GOOD Fast Track drive thru average 07:00
Any ideas?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread