View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default 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