Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2008

Tip: Looking for answers? Try searching our database.

Conditional format question..

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
simon steel - 12 Feb 2008 07:02 GMT
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.
Tom Hutchins - 12 Feb 2008 18:54 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.