Excel VBA/Formula
Closed
kennconese
Posts
1
Registration date
Monday March 31, 2014
Status
Member
Last seen
March 31, 2014
-
Mar 31, 2014 at 05:39 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 31, 2014 at 06:44 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 31, 2014 at 06:44 AM
Related:
- Excel VBA/Formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- How to enable vba in excel - Guide
- Number to words in excel without vba - Guide
- Excel date format dd.mm.yyyy - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Mar 31, 2014 at 06:44 AM
Mar 31, 2014 at 06:44 AM
USE CONDITIONAL FORMATTING
select A1:a4
conditional formatting
manage rules
use formulas
the formula is
=$A$5="complete"
applies to $A$1:$A$4
click ok
save the flle
now enter "complete" in A5 see what happens
select A1:a4
conditional formatting
manage rules
use formulas
the formula is
=$A$5="complete"
applies to $A$1:$A$4
click ok
save the flle
now enter "complete" in A5 see what happens