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 |
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) |