Conditional formatting

[Closed]
Report
Posts
1
Registration date
Saturday October 12, 2013
Status
Member
Last seen
October 12, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

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