Using formula for conditional formatting
Closed
Richard
-
12 May 2016 à 09:28
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 12 May 2016 à 09:37
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 12 May 2016 à 09:37
Related:
- Conditional formatting formula
- Logitech formula vibration feedback wheel - Download - Drivers
- Excel clear formatting - Guide
- Spreadsheet formula - Guide
- Excel conditional formatting based on date - Guide
- Grade formula in excel marksheet - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
12 May 2016 à 09:37
12 May 2016 à 09:37
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.