Conditional formatting specific phrase－software｜痞客邦

Apr 21 Sat 2007 20:37
Conditional formatting specific phrase

close

Is it possible to format only cells that specifically read $0.00? Every time
I try all the blank cells and cells reading 0 also change.

You could try something like

=AND(A1=0,A1lt;gt;quot;quot;,LEFT(CELL(quot;formatquot;,A1),1)=quot;Cquot;)

however it's not very reliable--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Jkalschquot; gt; wrote in message
news
gt; Is it possible to format only cells that specifically read $0.00? Every
gt; time
gt; I try all the blank cells and cells reading 0 also change.

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Turning off merge message
此分類下一篇： conditions in quot;countifquot;
上一篇： Excel hyperlinks to other cells in workbook must be relative
下一篇： Lookup?

歷史上的今天

2007: How do I sort a range of cells via a worksheet function
2007: Save Excel File every wednesday VB Script Help !!
2007: How to reference a worksheet name
2007: Week Number
2007: Function question
2007: Formatting
2007: Please help
2007: Delete empty rows with cell type 2
2007: Function to add different values
2007: If Statement!!
2007: Consoildating Rows
2007: Brackets or paranthesis around negative numbers in Excel
2007: automatically hide row if cell contains asterisk
2007: Arrow keys to move cell
2007: how do I quot;freezequot; the left hand title column
2007: How do I set up a search macro in Excel?
2007: Pivotable Sum of Cost times Quantity
2007: Remove all formatting
2007: Calling for pages before they are created.
2007: formula to calulate length of time
2007: EARN OVER 9850 DOLLAR in 3 WEEKS !!!
2007: How can I move several columns of words into one column in Excel?
2007: size distribution curves
2007: automatically numbering rows
2007: Deleting Objects Copied from Web Page
2007: Automatically insert/delete rows to be x apart
2007: forcing value into remote cell
2007: Editing Macro
2007: What exactly is office, excel, and encarta?
2007: I know Excel can help me with keeping track of due dates
2007: Hyperlinks
2007: How do I link cells from a workbook, to talley one one sheet?
2007: Excel CSV files
2007: reference
2007: Group and Count Text Data More Efficiently
2007: Conditional Formating
2007: Comparing databases and returning values
2007: How do I fix a column in excel?
2007: why do they ask for the cartoon on an Excel Test
2007: Sorting help needed!
2007: Lookup table returns #N/A
2007: Customising Footers
2007: Automatic Fills Applied To Cells After Entering a Number
2007: Muliple formulas
2007: Looking for a Function which counts the repeatition of text in a column
2007: What's wrong with my Help files?
2007: UK Excel User Conference
2007: Viewing in web
2007: How to refresh data analysis tool results
2007: Percentage Discount Total
2007: excell feezes
2007: excel send to
2007: EARN OVER 9850 DOLLAR in 3 WEEKS !!!
2007: add a value to and then multiply values of multiple codes in one c
2007: Printing
2007: compare lists
2007: Is this formula 100*(PRODUCT(1 C3:N3/100)-1) recognised by Excel
2007: mortgage formulas etc..
2007: List combinations of a range
2007: number of fields in the row fields in pivot table
2007: Drag drop filenames
2007: What is the -
2007: Sorting in Excel
2007: Help
2007: Hyperlink failed
2007: Formula not Return Required Answer Q
2007: Form Causes Out of Memory
2007: the Statistical symbol quot;Xbarquot;
2007: External Links and Multiple Instances
2007: Date Format Correct, But Formula Error
2007: Adding Trendline To Just Some of the Bars in Chart
2007: Macro to Delete blank cells
2007: Find text within text
2007: How can I make a chart with column A on xaxis amp; column B on Yaxis
2007: Deleting blank spaces in cells
2007: multiple page if statement
2007: How do I make a quot;Worksheet_Change eventquot; to show any changes to cells?
2007: need help with count formula..
2007: Calculated fields in pivot tables
2007: How to access Excel forum through Outlook Express
2007: How do I show the current Excel filepath in the toolbar line?
2007: In between the sheets?
2007: How can I show connections among cells/values?
2007: Help Help Help Help!!!
2007: how do I format data into columns using a pivot table report?
2007: Data Validation
2007: Can Excel open a new application for every file opened?
2007: How can I make the rows go into a random order?
2007: Query to find last saved date/Time
2007: Basic if formula
2007: Indirect or Vlookup or what....
2007: numbers to text with formatting
2007: Tracking Errors
2007: HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
2007: Multiple V Lookups
2007: I'm trying to convert . to ,
2007: Delete rows with duplicate values
2007: is there a function that will multiply different cells
2007: How do I find a certain symbol in cells?
2007: combining duplicate rows

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)