Change color of cells in Excel based on data in other cells
Closed
brohera
-
Jun 20, 2016 at 04:43 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 20, 2016 at 04:58 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 20, 2016 at 04:58 PM
Related:
- Change color of cells in Excel based on data in other cells
- Notepad++ change background color - Guide
- Screenshot excel cells - Guide
- How to change author in excel - Guide
- Position formula in excel ✓ - Office Software Forum
- Transfer data from one excel worksheet to another automatically - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 20, 2016 at 04:58 PM
Jun 20, 2016 at 04:58 PM
Try to use:
Select A1
Conditional Formating:
Formula:
=AND(A1=0,AF1=5)
Choose the color RED for FONT COLOR.
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Select A1
Conditional Formating:
Formula:
=AND(A1=0,AF1=5)
Choose the color RED for FONT COLOR.
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão