Conditional formating
Closed
ROB_L
Posts
1
Registration date
Tuesday August 19, 2014
Status
Member
Last seen
August 19, 2014
-
Aug 19, 2014 at 07:13 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 21, 2014 at 06:43 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 21, 2014 at 06:43 PM
Related:
- Conditional formating
- 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 conditional formatting if another cell contains specific text - 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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 21, 2014 at 06:43 PM
Aug 21, 2014 at 06:43 PM
ROB_L, Good evening.
Select A1.
Menu Conditional Formatting.
New Rule.
Using Formulas.
=B2>=A1+10000
....Choose RED as fill cell.
OK
Apply to $A$1:$A$70
This rule does exactly what you asked for.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Select A1.
Menu Conditional Formatting.
New Rule.
Using Formulas.
=B2>=A1+10000
....Choose RED as fill cell.
OK
Apply to $A$1:$A$70
This rule does exactly what you asked for.
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão