Using formula for conditional formatting
Closed
Richard
-
May 12, 2016 at 09:28 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 12, 2016 at 09:37 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 12, 2016 at 09:37 AM
Related:
- Using formula for conditional formatting
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 12, 2016 at 09:37 AM
May 12, 2016 at 09:37 AM
Richard, Good morning.
Try to use:
Select H5
Conditional Formating:
Formula:
=AND(B5<>" ";B5>0)
Choose the color you want.
Please, tell us if it worked for you.
I hope it helps.
Try to use:
Select H5
Conditional Formating:
Formula:
=AND(B5<>" ";B5>0)
Choose the color you want.
Please, tell us if it worked for you.
I hope it helps.