Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cells and font by content/whether formula present | Excel Worksheet Functions | |||
Condition format a row based on a formula | Excel Worksheet Functions | |||
Condition format a row based on a formula | Excel Worksheet Functions | |||
Condition Format a Day that resulted from a formula | Excel Discussion (Misc queries) | |||
how to use time format to present negative value? ex. -00:42 min | Excel Discussion (Misc queries) |