How do I add that to Condition formattingPerhaps this:
Book1
A B C D E F G 1 Yes 2 No 3 Yes 4 Yes 5 No Sheet1
Cells with Conditional Formatting Cell Condition Cell Format Stop If True A1:A5 Expression =$G1="Yes" text NO
Select the cells you want the CF rule to apply to, column A in this case. Select Conditional Formatting on the ribbon:How do I add that to Condition formatting
What are you trying to check with that?
That is checking to see if the literal text of "MM/DD/YYYY" appears in cell A1
=ISNUMBER($A1)
Thank youIn Excel, dates are really just numbers with date formats applied to them.
Specifically, it is the number of days since 1/0/1900 (change the format of any cell with a date in it to General, and you will be able to see the date as Excel does).
Time is just the fractional piece of one day (i.e. 12 Noon would be 0.5).
Since dates are just numbers, you can use the formula:
to check for a numeric entry in cell A1.Excel Formula:=ISNUMBER($A1)