Help- conditional cell formatting
Solved/Closed
campbellty10
Posts
2
Registration date
Monday November 20, 2017
Status
Member
Last seen
November 21, 2017
-
Nov 20, 2017 at 12:56 PM
campbellty10 Posts 2 Registration date Monday November 20, 2017 Status Member Last seen November 21, 2017 - Nov 21, 2017 at 09:13 AM
campbellty10 Posts 2 Registration date Monday November 20, 2017 Status Member Last seen November 21, 2017 - Nov 21, 2017 at 09:13 AM
Related:
- Help- conditional cell formatting
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Count if cell contains number - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Phone formatting software for pc - Download - File management
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 20, 2017 at 01:27 PM
Nov 20, 2017 at 01:27 PM
campbellt10, Good afternoon.
Select your B cell that contains a Conditional Format.
Go to CF Menu
Manager Rules
Change the range at that little blue square at window to your desired range.
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Select your B cell that contains a Conditional Format.
Go to CF Menu
Manager Rules
Change the range at that little blue square at window to your desired range.
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Nov 21, 2017 at 09:13 AM
I actually had that part in the blue area, I ended up needing to change the formula to match yours.
Looks like I needed to go to new rule and actually write out the formula instead of setting it up through the "greater than" and "less than" buttons under the conditional formatting drop down.
Thanks!