Conditional formatting
Closed
kellebelle34
-
Jan 14, 2010 at 01:07 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 14, 2010 at 09:02 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 14, 2010 at 09:02 PM
Related:
- Conditional formatting
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Copy conditional formatting but change reference cell ✓ - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 14, 2010 at 09:02 PM
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
