Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I am trying to colour format a row of four cells contained in four columns.
The numbers in the rows change as values are input progressively to rows in other cells of the spreadsheet but remain constant once past the current row. In the example below, when a value is entered in cell a2, the values in e2,f2,g2,&h2 will change and the values in e1,e2,e3,& e4 will become constant. What I am trying to do using the example below is to have cells less than 4 formatted as green, greater than 4 as red and equal to 4 no colour formatting. So before I enter data in cell a2, e1 will be green, f1 none, g1 red and h1 green. So far I can do this using Conditional Formatting. What I now want to do before I enter data in cell a3, is clear the colours in cells e1,f1,g1& h1 and apply it to cells e2,f2,g2 & h2. So e1 to h1 will still have values 2,4,11 & 3 but with no formatting and e2 will be red, f2 green, g2 green & h2 none. At any one time only one row of four cells will be highlighted. Any help appreciated. e.g. e f g h 1 2 4 11 3 2 10 2 1 4 3 1 4 2 3 Thanks, Mal |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
If you already have conditional formatting set up for row 1, then
before you enter any data into row 2 you can highlight the cells in the previous row, click the Format Painter icon then click and highlight the same cells in the next row (i.e. where you want to put the new data). You could then remove the CF which applied to the cells in the previous row. Then start entering your data. This is a procedural method - would you prefer a formula? Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |