conditional formatting
Hi,
I assume your information starts in cell 1 so in column E1 enter
=IF(C1=F1,"=",IF(C1F1,"",IF(C1="","",IF(C1<F1,"< "))))
I add an option to show blank if cell C1 is blank
"out0015" wrote:
A B C
1 2895 59 TH ST ELEMENTARY 28
2 5466 6 TH AVE ELEMENTARY 49
3 7855 6 TH AVE ELEMENTARY 6
4 2954 92 ND ST ELEMENTARY 21
5 5677 93 RD ST ELEMENTARY 60
D E F
8 2895 59 TH ST ELEMENTARY 28
9 5466 6 TH AVE ELEMENTARY 50
10 2954 92 ND ST ELEMENTARY 23
11 5677 93 RD ST ELEMENTARY 60
if C column is less than F display < in column e
if C column is greater than F display in column e
if C column is = to F display =
Thanks
|