LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 172
Default conditionl format overrides explicit format

I have a conditional format that I use in a column. The first
condition is a formula, =isempty(a5) and the format is set to "No
Format". This works fine most of the time but occassionly in this
column is a row that has background color explicitly set and the
conditional format, even though it says "No Format" the background
color is removed. Is there anyway to overcome this behavior?

Excel 2003

Thanks for any ideas.


John Keith

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
Excel 2003 Sheet Ptotection with Overrides to sort Techtrainer Excel Worksheet Functions 0 June 26th 08 09:38 PM
Conditionl Format TeddyTash Excel Worksheet Functions 3 September 14th 05 10:35 AM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 12:57 PM
Formula and Conditionl Formatting Help Phyliss Excel Worksheet Functions 3 November 16th 04 07:40 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"