Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2011, 08:11 AM
Bacchanal Promotions Bacchanal Promotions is offline Automatic Formatting for whole row Windows Vista Automatic Formatting for whole row Office 2010 64bit
Novice
Automatic Formatting for whole row
 
Join Date: Mar 2011
Posts: 2
Bacchanal Promotions is on a distinguished road
Post Automatic Formatting for whole row

Hello,

I would like to have my spreadsheet automatically format an entire row, rather than only a single cell. Given a criteria in one cell, I would like the cell style (normal/good/bad/neutral) to change for the full row.



For example:

If I have dates in column A, phone numbers in B, name in C, and status in D, I would like each row with status reading "Confirmed" to have the "good" cell style. I can format so Column D does this, but can't figure out how to set it up so the whole row changes.

Any help would be appreciated, thanks!!!
Reply With Quote
  #2  
Old 03-19-2011, 02:31 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Automatic Formatting for whole row Windows 7 32bit Automatic Formatting for whole row Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hello,

You can do this with conditional formatting. Conditional formatting is volatile so, to keep a fast running worksheet, the idea is to limit the area you apply it to. In the attached example I did the following:

  • Select A2:D12
  • Home tab > Conditional Formatting > New Rule
  • Select a rule type: Use a formula to determine which cells to format
  • Format values where this formula is true: =$D2="Confirmed"
  • Pick the format you want
In the formula, the column is fixed by the $ sign but the row number is not, so it will automatically adjust for you down to row 12.
Attached Files
File Type: xlsx Book1.xlsx (9.0 KB, 15 views)
Reply With Quote
  #3  
Old 03-19-2011, 05:12 AM
Bacchanal Promotions Bacchanal Promotions is offline Automatic Formatting for whole row Windows Vista Automatic Formatting for whole row Office 2010 64bit
Novice
Automatic Formatting for whole row
 
Join Date: Mar 2011
Posts: 2
Bacchanal Promotions is on a distinguished road
Default

You're a genius. Thank you so much, that was exactly what I was looking for.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic calendar camlad Excel 2 12-05-2010 03:49 PM
Automatic Formatting for whole row Office 2007 Mail Merge Issue - automatic formatting and revisions balloons sharpie21 Office 1 10-10-2010 03:56 AM
Automatic Formatting for whole row problem with automatic formatting on quotation marks Bobosmite Word 3 05-27-2010 07:06 PM
Automatic bcc nickynono Outlook 0 06-13-2006 02:30 PM
Automatic Formatting for whole row Automatic email pop up anitadzebic Outlook 4 03-09-2006 08:33 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft