If you want the formatting to apply to one specific row, select
the entire row, go to the Conditional Formatting dialog, change
"Cell Value Is" to "Formula Is" and enter
=COUNTA($A$4:$IV$4)<0
and set the format to a fill pattern. Change the '4' in the above
formula to the appropriate row.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"mykaltx"
wrote in message
...
I would like to write a formula that highlights the entire row
of
information when one cell is populated. Is there a way to do
that? I
know under conditional formatting you can change one cell when
information is populated. However, this is limited to one cell.
Unless,
I have missed something. Please help.
--
mykaltx
------------------------------------------------------------------------
mykaltx's Profile:
http://www.excelforum.com/member.php...o&userid=22055
View this thread:
http://www.excelforum.com/showthread...hreadid=510667