Excel Conditional Formatting color multiple cells for 1 logical
Currently, Excel Conditional formatting permits the user to format one cell
based upon the value in that cell. I would like to see this improved upon - the ability to format multiple cells depending upon the value of a single cell - eg a whole row or column could be hi-lited a color depending upon the value in one of the cells in that row or column. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Excel Conditional Formatting color multiple cells for 1 logical
You can set conditional format for the whole of row 1 with the formula
=($B1=3), and then if B1 = 3 the whole row will be formatted. -- David Biddulph "LDUNN1" wrote in message ... Currently, Excel Conditional formatting permits the user to format one cell based upon the value in that cell. I would like to see this improved upon - the ability to format multiple cells depending upon the value of a single cell - eg a whole row or column could be hi-lited a color depending upon the value in one of the cells in that row or column. |
Excel Conditional Formatting color multiple cells for 1 logica
Thanks David - this works!! Just goes to show you can always learn more
tricks in Excel!!!! "David Biddulph" wrote: You can set conditional format for the whole of row 1 with the formula =($B1=3), and then if B1 = 3 the whole row will be formatted. -- David Biddulph "LDUNN1" wrote in message ... Currently, Excel Conditional formatting permits the user to format one cell based upon the value in that cell. I would like to see this improved upon - the ability to format multiple cells depending upon the value of a single cell - eg a whole row or column could be hi-lited a color depending upon the value in one of the cells in that row or column. |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com