Conditional format question..

  • Thread starter Thread starter simon steel
  • Start date Start date
S

simon steel

Can't seem to figure this out...

Three columns of data.

If the value in column 1 is a text string that is "N/A" I want to format
cells, for that row, in column 2 & 3 (which will be empty of text) with a
border line that runs diagonally from top left to bottom right of each cell.

SS.
 
In Excel 2003 also you can only set the outside boders using conditional
formatting, not the interior. However, you can use conditional formatting to
fill the cell with a pattern of diagonal lines from upper left to lower
right. To try it:

Select columns B & C.
Select Conditional Formatting from the Format menu.
Set the dropdown to "Formula Is".
In the formula box enter =($A1="N/A")
Click the Format button.
Select the Patterns tab, then click the Pattern dropdown.
Choose a pattern, then click OK until the conditional formatting dialog is
closed.

Hope this helps,

Hutch
 
Back
Top