Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Condition Format where no formula present

I have a spreadsheet where it contains a lot of date formulas, but I need to
see when I hard key a date. How do I conditional format for that?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Condition Format where no formula present

See this:

http://groups.google.com/group/micro...cf859ecd?tvc=2

--
Biff
Microsoft Excel MVP


"RingDing" wrote in message
...
I have a spreadsheet where it contains a lot of date formulas, but I need
to
see when I hard key a date. How do I conditional format for that?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default Condition Format where no formula present

Hi RingDing,

Create the following User Defined Funciton (UDF) in a Visual Basic Module
(Alt F11 from the worksheet), make sure that this is in a Module.

Function NotFormula(cell)
NotFormula = Not cell.HasFormula AND Not IsEmpty(cell)
End Function

then save the Visual Basic.

Back to your worksheet, select the cells to apply conditional formatting to.
From the Conditional Formatting menu - select New Formatting Rule, then
select Use a formula to determine which cells to format.

In the Format values where this formula is true field, enter =NotFormula(A2)

Assuming A2 is the first cell in the range of cells to be conditionally
formatted.

Then set the format such as fill color or font color, then click OK.

Hope this helps.
--
If this post helps click Yes
---------------
Peggy Shepard


"RingDing" wrote:

I have a spreadsheet where it contains a lot of date formulas, but I need to
see when I hard key a date. How do I conditional format for that?

Reply
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
Format cells and font by content/whether formula present LJT87 Excel Worksheet Functions 2 January 8th 09 08:22 PM
Condition format a row based on a formula Tysmema Excel Worksheet Functions 2 May 2nd 08 02:22 PM
Condition format a row based on a formula Tysmema Excel Worksheet Functions 1 May 2nd 08 02:20 PM
Condition Format a Day that resulted from a formula Sunnyskies Excel Discussion (Misc queries) 4 February 2nd 07 02:24 PM
how to use time format to present negative value? ex. -00:42 min hass Excel Discussion (Misc queries) 4 April 19th 05 06:04 AM


All times are GMT +1. The time now is 11:53 AM.

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

About Us

"It's about Microsoft Excel"