Conditional format question..

[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.

 

[Gord Dibben]

Pete

Still no change in this feature in Excel 2003

No diagonal borders in CF


Gord

 

[Tom Hutchins]

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

 

[Pete_UK]

Okay, thanks Gord.

Pete

Pete

Still no change in this feature in Excel 2003

No diagonal borders in CF

Gord





- Show quoted text -

 

[simon steel]

Hutch.

Thanks - had not thought of this..
That will be close enough..

SS