Conditional Formatting when a cell says "NO"
Solved/Closed
Grace C
-
Jul 18, 2016 at 12:02 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 18, 2016 at 02:24 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 18, 2016 at 02:24 PM
Related:
- Conditional Formatting when a cell says "NO"
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Count if cell contains number - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 18, 2016 at 02:16 PM
Jul 18, 2016 at 02:16 PM
Grace C, Good afternoon.
Select the rows you want.
Ex.: 1 to 10
Conditional format menu
Using formula
Formula --> =$J1="NO"
Choose Fill selection any color you want.
OK
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Select the rows you want.
Ex.: 1 to 10
Conditional format menu
Using formula
Formula --> =$J1="NO"
Choose Fill selection any color you want.
OK
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 18, 2016 at 02:24 PM
Jul 18, 2016 at 02:24 PM
Hi Grace C,
>>>> All the best for you <<<<
Thanks for the feedback.
--
Belo Horizonte, Brasil.
Marcílio Lobão
>>>> All the best for you <<<<
Thanks for the feedback.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jul 18, 2016 at 02:21 PM
A ton of thanks.. this is amazing.. have a wonderful day!!! you made my billing life way easier