Conditional formatting of rows.
Posted by Dave Stimpson on September 28, 1999 2:19 PM
I have two columns of data headed "Risk" and "Impact".They each contain the values "High", "Medium" or "Low". I can use conditional formatting to highlight the individual cells - what I really want to do is highlight a whole row when the value in each of the two columns is "High"
Anybody got a quick fix for?
Posted by Ivan Moala on September 29, 1999 12:55 AM
if you have the cells cond. formated already,
then click on it again, select Format ,select cond. format,
you should have the format conditions displayed
and the formula you used ??
ie. you should have used <Formula is> and your
formula should by default read something like
=AND($D$2="High",$E$2="High") D2 & E2 I'm assuming
is the Row under your RISK & IMPACT headings.
You should remove the Absolute referece for the
Rows eg your formula should read
=AND($D2="High",$E2="High"). Click OK after this.
Then click on the <Format painter>;
If you haven't got this then;
1) Goto Tools
2) Select Customise
3) Select Commands in the dialog options
4) Under Catorgories select <Format>
5) Scroll down on commands until you see
Format painter
6) Click & drag this to a commandbar.
When you have the format painter it is just
a matter of selecting the cell with the cond.Format
THEN clicking the format painter (you should see
a paintbrush replacing the arrow.
Then select the Range of cells to format by
clicking and dragging over the range you want
conditionally formated.
Note if you have a number of ranges to do like this
then Double click on the format painter, every cell
you select by clicking on will be formated.
Press escape to get out of the formater.
NB: With the above formula is: I have assumed that you
wanted BOTH RISK & IMPACT to be High before the
formating occurs ??
Ivan
Posted by Ivan on September 29, 1999 12:58 AM
Error in statement via use of
