Conditional Formatting

[ziad alsayed]

dear all

i am trying to apply conditional formating in clomn C, is value in C is bigger than value in A to colour the value in C with red.

Excel Workbook
	A	B	C
1	BASIC	SP	BASIC
2	50	1272050	30
3	45	1369550	40
4	90	1460550	89
5	95	1649700	110
6	40	1836900	40
7	500	2166450	700
8	800	2393950	768
Sheet2

Excel 2010

hope you can assist

 

[T. Valko]

dear all

i am trying to apply conditional formating in clomn C, is value in C is bigger than value in A to colour the value in C with red.

Excel Workbook
	A	B	C
1	BASIC	SP	BASIC
2	50	1272050	30
3	45	1369550	40
4	90	1460550	89
5	95	1649700	110
6	40	1836900	40
7	500	2166450	700
8	800	2393950	768
Sheet2

Excel 2010



hope you can assist

Select the *entire* range C2:C8 starting from cell C2.
Cell C2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format

Enter this formula in the box below:

=AND(A2<>"",C2>A2)

Click the Format button

Select the desired style(s)

OK out

 

[VoG]

Try this

Excel Workbook
	A	B	C
1	BASIC	SP	BASIC
2	50	1272050	30
3	45	1369550	40
4	90	1460550	89
5	95	1649700	110
6	40	1836900	40
7	500	2166450	700
8	800	2393950	768
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2	1. / Formula is =C2>A2	Abc

 

[cummingsea]

bump

 

[ziad alsayed]

thanks T. Valko, it works.

 

[ziad alsayed]

thanks VoG , it works.

 

[T. Valko]

thanks T. Valko, it works.

You're welcome. Thanks for the feedback!