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 1864 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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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
0