LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Negative Conditional Formatting Excel 2003

Thank you for your answer, I still need to explain it a bit more as I have
worked out the answer, I do want to find out if it has been done by Microsoft.
I can set up the Criteria for Conditional Formatting which will work fine by
putting a colour in the cell, But by putting a Negative Conditional Formula
inthe same cell, I can prevent the colour format from showing up in the
cell even though the format is correct. It can be used for Desired
Coincidence Detection. I hope this explains it a bit better. Cheers 16 -
7 - 09
--
Srus


"Arceedee" wrote:

Unless I have misunderstood then you shouldn't need to do anything to achieve
your goal. If you have correctly set the criteria for conditional formatting
then it will only occur when you want it to.


"Quandary" wrote:

I would like to find out if anyone knows about Negative Conditional
Formatting for Excel 2003 using WindowsXP . A formula to prevent
Conditional Formatting to occur in a cell, or multiple cells, unless there is
a Letter or Character in the cell.
No Character--- Conditional Formatting will not apply.
--
Srus 14 - 7 - 09

 
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
Conditional formatting excel 2003 Kostas Excel Discussion (Misc queries) 2 April 2nd 09 12:11 PM
Conditional Formatting - Excel 2003 Dan Excel Discussion (Misc queries) 3 September 9th 08 04:43 PM
Conditional Formatting for Excel 2003 Lee Excel Discussion (Misc queries) 3 May 31st 08 01:29 AM
Conditional formatting excel 2003 [email protected] Excel Worksheet Functions 1 April 14th 08 11:43 AM
Excel 2003: Conditional Formatting oceanmist Excel Discussion (Misc queries) 3 September 20th 06 10:55 PM


All times are GMT +1. The time now is 08:52 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"