Conditional Formatting
 

Can someone show me how to provide conditional formatting for the following:


A B C D E
1 Jan-07 Feb-07 Mar-07 Total
2 forecast 5 8 10 23
3 % comp 22% 35% 43%
4 goal 33% 67% 100%
5
6
7
8 Green 90%+
9 Yellow between
10 Red 70%-


Applying the formatting to the items in row 3. Thanks for your help.

Conditional Formatting
 

Highlight row 3
in CF:
1st condition cell value is: 0.90 ... set to green
2st condition cell value is: between 0.70 and 0.90 ... set to yellow
3rd condition cell value is: < 0.70 ... set to red

HTH


"rook" wrote:

Can someone show me how to provide conditional formatting for the following:


A B C D E
1 Jan-07 Feb-07 Mar-07 Total
2 forecast 5 8 10 23
3 % comp 22% 35% 43%
4 goal 33% 67% 100%
5
6
7
8 Green 90%+
9 Yellow between
10 Red 70%-


Applying the formatting to the items in row 3. Thanks for your help.

Conditional Formatting
 

Highlight the cell that you want to Conditionally Format - say A3:C3 Cell
A3 will be the active cell so then in the Conditional Formatting dialog box
enter:

Condition 1:
Select Formula is:
=AND(A3<"",A3=90%)
and select Green Format

Condition 2:
Select Formula is:
=AND(A3<"",A3=70%,A3<90%)
and select Yellow format

Condition 3:
Select Formula is:
==AND(A3<"",A3<70%)
and select Red format

Note that if you enter the cell reference by clicking into the cell it will
be entered as an absolute range (like $A$3 ) and this will be entered in all
the selected cells. If you enter a relative cell reference as above the
cell reference in the other cell will be indexed up to that cell reference

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rook" wrote in message
...
Can someone show me how to provide conditional formatting for the
following:


A B C D E
1 Jan-07 Feb-07 Mar-07 Total
2 forecast 5 8 10 23
3 % comp 22% 35% 43%
4 goal 33% 67% 100%
5
6
7
8 Green 90%+
9 Yellow between
10 Red 70%-


Applying the formatting to the items in row 3. Thanks for your help.

Conditional Formatting
 

Thanks, That works!

"Sandy Mann" wrote:

Highlight the cell that you want to Conditionally Format - say A3:C3 Cell
A3 will be the active cell so then in the Conditional Formatting dialog box
enter:

Condition 1:
Select Formula is:
=AND(A3<"",A3=90%)
and select Green Format

Condition 2:
Select Formula is:
=AND(A3<"",A3=70%,A3<90%)
and select Yellow format

Condition 3:
Select Formula is:
==AND(A3<"",A3<70%)
and select Red format

Note that if you enter the cell reference by clicking into the cell it will
be entered as an absolute range (like $A$3 ) and this will be entered in all
the selected cells. If you enter a relative cell reference as above the
cell reference in the other cell will be indexed up to that cell reference

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rook" wrote in message
...
Can someone show me how to provide conditional formatting for the
following:


A B C D E
1 Jan-07 Feb-07 Mar-07 Total
2 forecast 5 8 10 23
3 % comp 22% 35% 43%
4 goal 33% 67% 100%
5
6
7
8 Green 90%+
9 Yellow between
10 Red 70%-


Applying the formatting to the items in row 3. Thanks for your help.

Conditional Formatting
 

You're very welcome. Thanks for the feedback.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rook" wrote in message
...
Thanks, That works!

"Sandy Mann" wrote:

Highlight the cell that you want to Conditionally Format - say A3:C3
Cell
A3 will be the active cell so then in the Conditional Formatting dialog
box
enter:

Condition 1:
Select Formula is:
=AND(A3<"",A3=90%)
and select Green Format

Condition 2:
Select Formula is:
=AND(A3<"",A3=70%,A3<90%)
and select Yellow format

Condition 3:
Select Formula is:
==AND(A3<"",A3<70%)
and select Red format

Note that if you enter the cell reference by clicking into the cell it
will
be entered as an absolute range (like $A$3 ) and this will be entered in
all
the selected cells. If you enter a relative cell reference as above the
cell reference in the other cell will be indexed up to that cell
reference

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rook" wrote in message
...
Can someone show me how to provide conditional formatting for the
following:


A B C D E
1 Jan-07 Feb-07 Mar-07 Total
2 forecast 5 8 10 23
3 % comp 22% 35% 43%
4 goal 33% 67% 100%
5
6
7
8 Green 90%+
9 Yellow between
10 Red 70%-


Applying the formatting to the items in row 3. Thanks for your help.