Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |