Conditional Formatting Based on another cell
Closed
Hannah
-
Jul 4, 2015 at 03:00 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 4, 2015 at 04:32 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 4, 2015 at 04:32 PM
Related:
- Conditional Formatting Based on another cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- If a cell has text then return value ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 4, 2015 at 04:32 PM
Jul 4, 2015 at 04:32 PM
Hannah, Good afternoon.
Select C3:D3
Menu --> Conditional Format --> Use Formula
=OR($C3=0,$D3=0)
Select Format color as you desire.
OK
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Select C3:D3
Menu --> Conditional Format --> Use Formula
=OR($C3=0,$D3=0)
Select Format color as you desire.
OK
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão