Jock
I am not completely sure what you are trying to do, but, I think you
may find it easier to work with the conditional formatting if you do
not include the &$" test" as part of your formula. You can get the
word "test" to show up in cells A3:B6 with a custom number formula
like "0 \t\e\s\t". The custom number formula does not preclude the
use of a conditional format statement to manipulate the font, pattern,
color etc. and the condition will probably be easier to deal with
without the text appended via formula.
Good luck.
Ken




On Nov 20, 9:31 am, Jock wrote:
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