Highlight
 

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

Highlight
 

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

Highlight
 

www.mykaltx.com


--
mykaltx
------------------------------------------------------------------------
mykaltx's Profile: http://www.excelforum.com/member.php...o&userid=22055
View this thread: http://www.excelforum.com/showthread...hreadid=510667