Excel VBA/Formula
Closed
kennconese
Posts
1
Registration date
Monday 31 March 2014
Status
Member
Last seen
31 March 2014
-
31 Mar 2014 à 05:39
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 31 Mar 2014 à 06:44
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 31 Mar 2014 à 06:44
Related:
- Excel VBA/Formula
- Excel vba find - Guide
- Formula to calculate vat in excel - Guide
- Vba excel mac - Guide
- Number to words in excel formula without vba - Guide
- Excel vba timer - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
31 Mar 2014 à 06:44
31 Mar 2014 à 06:44
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
