Conditional formatting
Closed
kellebelle34
-
Jan 14, 2010 at 01:07 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Conditional formatting
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Conditional formatting excel if another cell contains text ✓ - Forum - Excel
- Conditional formatting if another cell is blank - Forum - Excel
- If cell contains date then conditional format - Guide
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
1 reply
venkat1926
Jan 14, 2010 at 09:02 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 14, 2010 at 09:02 PM
You have to chear the computer
suppose the formula is in A1
in S1 the conditional format is
formula is I34>1
choose the color pattern
DO NOT USE CONDTITIONAL FORMATTING
CELLS VALUE EQUAL TO 0(ZERO)
Strictly A1 is not blank it is having a formula
you can do an experiment
suppose due to formula A1 is blank
in another cell type
=A1=0 it will give false
suppose the formula is in A1
in S1 the conditional format is
formula is I34>1
choose the color pattern
DO NOT USE CONDTITIONAL FORMATTING
CELLS VALUE EQUAL TO 0(ZERO)
Strictly A1 is not blank it is having a formula
you can do an experiment
suppose due to formula A1 is blank
in another cell type
=A1=0 it will give false