If a cell contains a date

[DarkoDeign2]

Hi,

I need help with a formula for conditional formatting.

If cell A3 contains a date, then I would like to have cell AG2 formated (highlighted)
If cell A4 contains a date then I would like to have cell AG3 formated (highlighted)

Would appreciate your help with solving this for me.

 

[Joe4]

Dates are really just numbers in Excel, with special date formatting (specifically, the number of days since 1/0/1900).

So we can just check for a number/value greater than zero.
Do the following:
1. Select cells AG2 and AG3
2. Go to Conditional Formatting
3. Select "New Rule"
4. Select "User a formula to determine which cells to format"
5. Enter the following formula:

=AND(ISNUMBER(A3),A3>0)

6. Click the Format button
7. Go to the Fill tab
8. Choose your desired color
9. Click OK twice

 

[DarkoDeign2]

Hi again,

I tried the your suggestion but I got an error message in Excel.
I forgot to mention that I will have data in cells A2:A1500. These cells are have the cell formatting "Date", don't know if this is causing any issues in this case?

 

[Joe4]

You may have different regional settings as me.
Does your Excel use commas or semi-colons to separate arguments in your functions?

Try replacing the commas with semi-colons, i.e.

=AND(ISNUMBER(A3);A3>0)

To change the range, just select the entire range you want to apply this to in step 1 of my instructions above.

 

[DarkoDeign2]

That did it thanks!

 

[Joe4]

You are welcome.
Glad I was able to help!