| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numbers & text in same cell - conditional formatting
Hi All,
The following formula will count the number of times 'test' appears in the range and display that total number with the word 'test' I.E. "5 test" =COUNTIF($E$8:$E$68,"test")&" test" There are another 7 similar formulas in adjacent cells (A3:B6) How can I get conditional formatting to identify the number and format the cell as I would like? This is the formula I'm using for cf: =A3=MAX(($A$3:$A$6),($B$3:$B$6)) -- Help!! Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting text and numbers in a cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| change color of text in cell without conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| conditional formatting with numbers and text | Excel Worksheet Functions | |||
Threaded Mode
