LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monir
 
Posts: n/a
Default Conditional Formating a cell .. to Show Nothing .. if True

Hello;

If the value in cell M9 (entered or copied to) is text (or non numeric),
then don't show the value (leave the cell blank). I couldn't use the fill and
font colour formating if the condition is true, because the cell fill has a
different fill / font colour combination for each run of the w/b.

Could you please show me how the Conditional Formating "Formula Is =" would
look like in cell M9 ??

Thank you kindly.
 
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
Deferring conditional formatting? Pheasant Plucker® Excel Discussion (Misc queries) 14 March 17th 06 08:17 PM
Conditional coloring of Excel cells, based on adjacent cell values? Greg Stuart Excel Worksheet Functions 0 March 10th 06 10:14 PM
Conditional formating -identify blank cell Simon Smith Excel Worksheet Functions 3 March 9th 06 10:48 PM
How do I setup Conditional formating for a cell that has a yes or. Jerry at ECS Excel Discussion (Misc queries) 1 April 6th 05 03:19 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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