Excel VBA/Formula
Closed
kennconese
venkat1926
- Posts
- 1
- Registration date
- Monday March 31, 2014
- Status
- Member
- Last seen
- March 31, 2014
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel VBA/Formula
- Auto generate serial number in Excel: VBA, formula - Guide
- Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
- Convert numbers to words in Excel: without VBA, formula - Guide
- How to show or hide formula bar in Excel: VBA, shortcut - Guide
- How to apply same formula to multiple cells in excel vba - Guide
1 reply
venkat1926
Mar 31, 2014 at 06:44 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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