Conditional Formatting involving dates
Closed
Hello,
HI ,
I am trying to apply conditional formatting for a range of data in a column so that
if in a particular cell the date is not today() then it should be visible in font color black and if the date is today() then the following formatting is to be done
1. the cell color should be white , the font color should be white.
Please help
HI ,
I am trying to apply conditional formatting for a range of data in a column so that
if in a particular cell the date is not today() then it should be visible in font color black and if the date is today() then the following formatting is to be done
1. the cell color should be white , the font color should be white.
Please help
Related:
- Conditional Formatting involving dates
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Using nested if to blank out adjacent cells - Excel Forum
- Apple iphone 13 release dates - Guide
2 responses
Presumably your cell text is formatted black already
Format>Conditional Formatting
Cell value Is > Equal to > =TODAY() Format > Patterns = white, Font = White
Format>Conditional Formatting
Cell value Is > Equal to > =TODAY() Format > Patterns = white, Font = White
If I'm understanding you correctly then you could easily do this in Office 2007 under conditional formatting within the Home tab. You could use the conditional formatting BETWEEN and set the date then customize the formating in the popup window to white/white or us the A Date Occuring and set the popup window settings to Today then customize the formatting to white/white. Easily done in 07/10 Office. I hope that's what you needed.