Conditional Formatting

[gehusi]

I have a table in which I would like to conditional format the first column (A) if any of the cells in the remaining columns (B:CG) of that row are greater than or equal to five. As a truncated example:


<table border="0" cellpadding="0" cellspacing="0" width="360"><col style="width:54pt" span="5" width="72"> <tbody><tr style="height:14.25pt" height="19"> <td class="xl23" style="height:14.25pt;width:54pt" height="19" width="72">ABC</td> <td class="xl24" style="border-left:none;width:54pt" align="right" width="72">2</td> <td class="xl24" style="border-left:none;width:54pt" align="right" width="72">0</td> <td class="xl24" style="border-left:none;width:54pt" align="right" width="72">5</td> <td class="xl24" style="border-left:none;width:54pt" align="right" width="72">2</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl24" style="height:14.25pt;border-top:none" height="19">DEF</td> <td class="xl24" style="border-top:none;border-left:none" align="right">1</td> <td class="xl24" style="border-top:none;border-left:none" align="right">1</td> <td class="xl24" style="border-top:none;border-left:none" align="right">1</td> <td class="xl24" style="border-top:none;border-left:none" align="right">1</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl23" style="height:14.25pt;border-top:none" height="19">GHI</td> <td class="xl24" style="border-top:none;border-left:none" align="right">3</td> <td class="xl24" style="border-top:none;border-left:none" align="right">2</td> <td class="xl24" style="border-top:none;border-left:none" align="right">0</td> <td class="xl24" style="border-top:none;border-left:none" align="right">6</td> </tr> </tbody></table>
What formula could I enter for the conditional formatting in order to accomplish this?

 

[VoG]

Try this

Excel Workbook
	A	B	C	D	E
1	ABC	2	0	5	2
2	DEF	1	1	1	1
3	GHI	3	2	0	6
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =MAX(B1:E1)>=5	Abc

 

[gehusi]

All I can say is "duh"...and thanks