How to use Repeat Conditional Formatting function

[jray9242]

I have a want to able to do the following. I want to have 2 Conditional Formats in the "O" column.

The first one will look like this:

N2 <= O2 then GREEN
O2 > N2 then RED

Then I need to copy the format to row 18.

I have google this but can't seem to find the answer. Please help me with this.

Thank you

Jim


<title>Excel Jeanie HTML</title>

Excel Workbook
	N	O
1	Jul	Actual
2	214.00	214.00
3	14.95	0.00
4	0.00	0.00
5	254.00	0.00
6	120.00	131.97
7	150.00	0.00
8	19.95	0.00
Yearly

 

[Datsmart]

You can copy formatting by using the "Format Painter" icon.
Select the cell whose format you want to copy.
Click Format Painter, (Paint brush icon) in the Home Ribbon.
Now click the cell you want to Format the same.
The format, (including Conditional Formatting), will be transferred to new cell.

To paste formatting to multiple cells, drag the cell range desired.

 

[jray9242]

Thank you for the quick response. This is the results i get doing it your way

Excel Workbook
	N	O
1	Jul	Actual
2	214.00	214.00
3	14.95	0.00
4	0.00	0.00
5	254.00	0.00
6	120.00	131.97
7	150.00	0.00
8	19.95	0.00
9	0.00	0.00
10	0.00	0.00
11	20.00	19.73
12	0.00	42.74
13	0.00	0.00
14	254.00	249.90
15	0.00	0.00
16	200.00	200.00
17	55.00	55.00
18	118.65	118.65
Yearly

 

[Ingolf]

Hi,
Try this 2 formula (in conditional formating):
$N2 <= $O2 ---> GREEN
$O2 > $N2 ---> RED

First select the range N2:O18

 

[Marcelo Branco]

Hi,

Maybe i'm missing something but these rules overlap
N2 <= O2 then GREEN
O2 > N2 then RED

What do you want, for example, N2=1 and O2 =2? Green or Red? Both conditions are True...

Is this a typo? Maybe
N2 <= O2
N2 > O2

M.

 

[jray9242]

Actually Inglof has it correct.

N2 = 214.00
O2 = 214.00
So if O2 is less than or equal to N2, then GREEN
$N2 <= $O2 ---> GREEN

N2 - 214.00
O2 = 235.00
So if O2 is greater than N2, then RED
$O2 > $N2 ---> RED

Maybe my math is wrong

Or should it be like this.

O2 <= N2 = Green
O2 > N2 = RED

 

[Marcelo Branco]

Hi,

So if O2 is less than or equal to N2, then GREEN
$N2 <= $O2 ---> GREEN

Well... i think that
$N2 <= $O2 ---> GREEN
means if O2 greater or equal than N2 ---> GREEN

If you ned O2 less than or equal N2
N2 >= O2

M.

 

[jray9242]

Here is what I did and applying what has already been posted I got it to work.

$O2 <= $N2 = Green
$O2 > $N2 = Red

Thanks all!