Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
In Excel, I create a conditional formatting to highlite a duplicate
refference. The formatting applyied, as indicated when I click conditional formatting again, but does not display in the cell. I am useing Office 2003. I applied a red patern with white bold, but the cell does not display any change. |
#2
![]() |
|||
|
|||
![]()
You need to post your conditional format formula.
"Cashius War eagle" <Cashius War wrote in message ... In Excel, I create a conditional formatting to highlite a duplicate refference. The formatting applyied, as indicated when I click conditional formatting again, but does not display in the cell. I am useing Office 2003. I applied a red patern with white bold, but the cell does not display any change. |
#4
![]() |
|||
|
|||
![]()
Most likely there is an error in your formula, so that it is
not doing what you expect it to do. Try using the formula(s) on the spreadsheet itself in another column to see if it generates True [number not zero] or False [zero]. Conditional formatting only pays attention to True and ignores any errors. Conditional like normal cell formatting can be wiped out or copied from another cell by pasting into a cell. My page on Conditional Formatting is http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |