In Excel, how can we apply conditional formatting on dates excluding the time?

Answer You have to make sure that the Date/Time format is used on the cells in question. That way the true value will be a serial number, where the Days will be a whole number (an Integer) and the Times ... Read More »

Top Q&A For: In Excel, how can we apply conditional formatti...

How to Apply Conditional Formatting in Excel?

Spruce up important spreadsheets with conditional formatting to make them easier to read.Do you ever need to know when you are over or under budget? Want to pick out an important data from a huge l... Read More »

I need help with conditional formatting in Excel....?

Since you state the "entire workbook", the first thing you need to do is select all of your worksheets. Do this by clicking the very first one, and then while holding down the SHIFT key, click the... Read More »

Excel keeps changing my data into time/dates?

Before typing the text, select the cell, then right click, select format cells.When the window appears, on the left select 'text'. then click ok, and you r done.Hope it works.

Can you make me an Excel Conditional Row Delete Macro?

When you say "rows that have a 'V' in them", are you saying that is all that is found within the cell, or that the letter "V" might be just one of the characters in that cell for column M. It make... Read More »