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
> Can't seem to figure this out...
>
[quoted text clipped - 5 lines]
>
> SS.
simon steel - 12 Feb 2008 21:02 GMT
Hutch.
Thanks - had not thought of this..
That will be close enough..
SS
> In Excel 2003 also you can only set the outside boders using conditional
> formatting, not the interior. However, you can use conditional formatting
[quoted text clipped - 25 lines]
>>
>> SS.