Conditional formatting
Closed
dhoot
Posts
1
Registration date
Saturday October 12, 2013
Status
Member
Last seen
October 12, 2013
-
Oct 12, 2013 at 06:49 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 12, 2013 at 07:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 12, 2013 at 07:27 AM
I want to do conditional formation in that i have two columns where A (Due Date) & In B ( Remark) if my validation due date is pass then i want to highlighted it by red color till whenever we do remark as OK if we enter OK in column B then Highlighted the column A with green color
Related:
- 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
- Excel conditional formatting based on date - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 12, 2013 at 07:27 AM
Oct 12, 2013 at 07:27 AM
use these formulas in conditiona formatting
suppose row 1 is having heading
sselect A2
unde conditional foramttsing the two conditiona apply
=if(and(a2>=today(),B2<>"ok") format this as red
second rule
=if(and(a2>=today(),B2="ok") now format as gsrsese
now selesct A2 edit copy
select A3 down edit lpastespecial-formats
suppose row 1 is having heading
sselect A2
unde conditional foramttsing the two conditiona apply
=if(and(a2>=today(),B2<>"ok") format this as red
second rule
=if(and(a2>=today(),B2="ok") now format as gsrsese
now selesct A2 edit copy
select A3 down edit lpastespecial-formats
