Conditional Formating

  • Thread starter Thread starter Robert G. Flade, RN, MS
  • Start date Start date
R

Robert G. Flade, RN, MS

I have an Excel spreadsheet that has C3=4, C4=3, & C5=2 and I want to do
contitional formating for another cell to have an arrow showing a direction
based on C3 - C5 (e.g., if B3>C3 arrow up, if B3=C4 nothing, if B3<C5 arrow
down). Is there any way to do that? I can make a color of the cell but
would like to have a symbol.

Any help would be appreciated.
Thanks
Bob
--
Robert G. Flade, RN, MS
Director - Emergency Departments
The Hospital of Central CT
at New Britain General & Bradley Memorial
100 Grand Street/PO Box 100
New Britain, CT 06050-0100
 
so "the other cell" would be

=if(B3>C3,"",if(B3<C3,"á","â"))

and formatted as Format->Cells->Font->WingDings.
 
Thank you. . . that was soooo stupid of me. . . I should have known that. . .
I don't know why I was stuck on thinking "conditional formating" and not an
"if statement". . . duh. . . oh well. . . THANKS again.
Bob
--
Robert G. Flade, RN, MS
Director - Emergency Departments
The Hospital of Central CT
at New Britain General & Bradley Memorial
100 Grand Street/PO Box 100
New Britain, CT 06050-0100
 
Back
Top