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 |
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 |
All times are GMT +1. The time now is 01:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com