Conditional Formatting in Excel 2007

J

JOHN HARRIS

I have a spreadsheet that tracks the number of screens completed in doctors
offices each month. What I would like to do is set the CF in Excel07 so that
an arrow appears next to the number showing whether the screens for that
month increased, stayed the same, or decreased.

Col A Col B Col C
July August September
12 12 24

Nothing would be in Column A since it is the start point, Col B would have a
flat arrow, and Col C would show an UP arrow.

Cannot figure out how to do this, and would appreciate any help.

TIA
 
B

Bernard Liengme

Cf does not provide a way to add arrows
You could use colours
Let first cell be B2; select other cells in row 2; open CF dialog; use
Formula Is: =AND(C2>B2, C2<>"") and set a colour
click Add
Formula Is: =AND(C2=B2, C2<>"") and set another colour
click Add
Formula Is: =AND(C2<B2, C2<>"") and set a third colour

We could have arrows if you can use the cells below to hold them
best wishes
 
J

John C Harris

Thanks for the answer. In Excel 2007 you can use arrows in CF, along with
some other pretty things :). I know it was not in earlier versions. Only
problem is getting to those arrows in a useful way, which is what I am
trying to do.
 
B

Bernard Liengme

Select all the data to the right of the first value
Click Conditional Formatting on Ribbon
Use the Icon Set and select arrows
Will send a file to you private email if you contact me directly
best wishes
 
A

angela-garcia

JOHN HARRIS said:
I have a spreadsheet that tracks the number of screens completed in doctors
offices each month. What I would like to do is set the CF in Excel07 so
that an arrow appears next to the number showing whether the screens for
that month increased, stayed the same, or decreased.

Col A Col B Col C
July August September
12 12 24

Nothing would be in Column A since it is the start point, Col B would have
a flat arrow, and Col C would show an UP arrow.

Cannot figure out how to do this, and would appreciate any help.

TIA

--
JOHN C. HARRIS, MPA, MBA
JCZ CONSULTING OF TAMPA BAY
813-361-8826
[email protected]
Click to expand...
 
Top