Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting for adjacent cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Merged Cells | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |