Aidworker17
New Member
Dear All,
I have a work sheet where cells in a column could be (conditionally) formatted with a green background or a purple background; or of course no background.
Is it possible to conditionally format the first cell in the column - where the condition is something like <if any cell is in this column is purple or green>, and the format is <make the back ground of the first cell purple> ?
Similarly, if the worksheet has many columns that could be (conditionally) formatted with a green background or a purple background, is it possible
to conditionally format a dedicated cell (say in cell A1) - where the condition is something like <if any cell is in this worksheet is purple or green>, and the format is <make the back ground of the dedicated cell purple> ?
Similarly, could I have a separate worksheet to conditionally format a special cell - where the condition is something like <if any cell is in any worksheet in this spreadsheet is purple or green>, and the format is <make the back ground of the this special cell purple> ?
Kind regards,
Jonathan
I have a work sheet where cells in a column could be (conditionally) formatted with a green background or a purple background; or of course no background.
Is it possible to conditionally format the first cell in the column - where the condition is something like <if any cell is in this column is purple or green>, and the format is <make the back ground of the first cell purple> ?
Similarly, if the worksheet has many columns that could be (conditionally) formatted with a green background or a purple background, is it possible
to conditionally format a dedicated cell (say in cell A1) - where the condition is something like <if any cell is in this worksheet is purple or green>, and the format is <make the back ground of the dedicated cell purple> ?
Similarly, could I have a separate worksheet to conditionally format a special cell - where the condition is something like <if any cell is in any worksheet in this spreadsheet is purple or green>, and the format is <make the back ground of the this special cell purple> ?
Kind regards,
Jonathan