Conditional Formating
Closed
Lamees
-
Mar 1, 2012 at 10:44 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 1, 2012 at 10:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 1, 2012 at 10:25 PM
Related:
- Conditional Formating
- Excel conditional formatting if another cell contains specific text - 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
- Excel formula to change cell color without conditional formatting - Excel Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
- Copy conditional formatting but change reference cell ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 1, 2012 at 10:25 PM
Mar 1, 2012 at 10:25 PM
suppose first cell is A1 having the entry "standard"
and the second cell is B1 having entry either more than 3 or less than equal to 3
select B1
conditional formatting window
first
the cell value
greater than
3
dont do the formt now
click "add"
in the bottom window
the formula is
=OFFSET(B1,0,-1,1,1)="standard"
click the format
pattern
and choose color
click ok twice
and the second cell is B1 having entry either more than 3 or less than equal to 3
select B1
conditional formatting window
first
the cell value
greater than
3
dont do the formt now
click "add"
in the bottom window
the formula is
=OFFSET(B1,0,-1,1,1)="standard"
click the format
pattern
and choose color
click ok twice
