Highlight

[mykaltx]

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.

 

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[mykaltx]

www.mykaltx.com