Sep 27, 2024 · In conditional formatting, how do I identify cells that are blank to contain a specific formatting, i.e. I want to highlight all blank cells in a column?

Apr 16, 2025 · Need a formula or cond. formatting to return a positive and negative value in separate rows based on the same value in another column...

Apr 10, 2025 · Is there a conditional formatting I can apply to dates that are entered a certain number of times? I have a large database of names and referrals. When I receive information back from the …

Nov 29, 2022 · I have specific cells that I want to automatically appear with the text 'VACANT' if the manually entered data is removed. I have been unable to find how to do that on my own. Any help …

Oct 18, 2024 · I would like someone to assist with Conditional Formatting for dates .. I have an Invoice date in one column and a receival date in another column and I would like to be able to set a …

Sep 5, 2013 · Hi, can any body confirm this asymmetry? I can't use structured references in conditional formatting formulas.

Oct 22, 2024 · Hi everyone, We are tracking all of the staff training and we want to create some highlight cell rules. I can only find formulas that calculate with the =TODAY function and im not sure if this is …

Mar 29, 2022 · Hi, How to use VBA to create and remove conditional formatting at once click? My excel files is similar to the sample file - Dependent Data Validation Advanced (source: contextures), and …

Aug 5, 2010 · Conditional format for multiple colums Good after noon Im trying to highlight all cells red across a spread sheet that have the same type of data in certain columns.

Mar 16, 2011 · This assumes that you are using Excel 2007 as is stated at the top of the thread. For earlier versions, the WORKDAY function is part of the associated Analysis Tool Pak (provided with …