Excell Conditional Formatting
Closed
Rob37
-
Dec 25, 2011 at 02:27 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 25, 2011 at 09:41 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 25, 2011 at 09:41 PM
Related:
- Excell Conditional Formatting
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 25, 2011 at 09:41 PM
Dec 25, 2011 at 09:41 PM
select first cell (for e.g. A1)
in the conditional formatting first
the formula is
=and(A1>=today(),A1<>"")
then use color green
similar for the less then today
copy A1 down and pastespecial-format
in the conditional formatting first
the formula is
=and(A1>=today(),A1<>"")
then use color green
similar for the less then today
copy A1 down and pastespecial-format
