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
|