Conditional Formatting

[Guest]

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.

 

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Thanks, That works!

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

You're very welcome. Thanks for the feedback.

--

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk