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
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Conditional formatting based on date ✓ - Excel Forum
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
