Conditional formatting in Excel 2010
Closed
galaxynut
Posts
2
Registration date
Monday 17 March 2014
Status
Member
Last seen
19 March 2014
-
17 Mar 2014 à 15:16
galaxynut Posts 2 Registration date Monday 17 March 2014 Status Member Last seen 19 March 2014 - 19 Mar 2014 à 15:10
galaxynut Posts 2 Registration date Monday 17 March 2014 Status Member Last seen 19 March 2014 - 19 Mar 2014 à 15:10
Related:
- Conditional formatting in Excel 2010
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Pdf and xps add in 2010 - Download - Other
- Microsoft office 2010 free download - Download - Office suites
- Excel mod apk for pc - Download - Spreadsheets
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Mar 2014 à 15:27
17 Mar 2014 à 15:27
galaxynut, Good afternoon.
Try to do:
--> Select A1:A10
--> Menu Conditional format
--> New Rule --> Using formula
Formula --> =$A$1<>0
Use a format colour that you prefer.
OK
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to do:
--> Select A1:A10
--> Menu Conditional format
--> New Rule --> Using formula
Formula --> =$A$1<>0
Use a format colour that you prefer.
OK
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
galaxynut
Posts
2
Registration date
Monday 17 March 2014
Status
Member
Last seen
19 March 2014
19 Mar 2014 à 15:10
19 Mar 2014 à 15:10
Brilliant, it works perfectly, thank you!