Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight a row | Excel Discussion (Misc queries) | |||
Highlight if ? | Excel Programming | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
highlight row | Excel Programming |