Conditional Formatting IF not empty

0 votes

How can I conditionally format a cell so that it turns grey if it is not blank?

I attempted to use "not equal," but it was unsuccessful.

At work, I run Windows XP and Windows Office 2003. The following feature is not visible to me:

enter image description here

What I have tried so far:

enter image description here

Oct 21, 2022 in Others by Kithuzzz
• 38,000 points
617 views

1 answer to this question.

0 votes

 Use Conditional formatting with the option "Formula Is". One possible formula is:

=NOT(ISBLANK($B1))

enter image description here

answered Oct 22, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Conditional Formatting not applying to all the cells in a given range

Use the following instead as the Formula: =$P5=75% I ...READ MORE

answered Apr 7, 2023 in Others by Kithuzzz
• 38,000 points
634 views
0 votes
1 answer

How to check if array is multidimensional or not?

Since the 'second dimension' could be just ...READ MORE

answered Nov 5, 2018 in Others by DataKing99
• 8,250 points
5,958 views
0 votes
1 answer

Do We get the certificate if we attend both the days of the workshop and not do any assignments ?

Hi, @There, Yes, you can, if you have attended ...READ MORE

answered Sep 21, 2020 in Others by Gitika
• 65,770 points
2,285 views
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,600 points
1,864 views
0 votes
1 answer

Too Many Different Cell Formats

Cell formats are challenging. There isn't actually ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,600 points
533 views
0 votes
1 answer

Format an Excel Sheet in Python

The below code will help you refer ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,600 points
1,360 views
0 votes
1 answer

Excel formula to average selected cells based on certain criteria

Try: =AVERAGE(IF(X:X=A1,Z:Z)) With Ctrl+Shift+Enter. READ MORE

answered Nov 13, 2022 in Others by narikkadan
• 63,600 points
456 views
0 votes
1 answer

Conditional formatting with Index(Match), 2 conditions (vertical & horizontal)

Use FILTER to search using two or ...READ MORE

answered Jan 30, 2023 in Others by narikkadan
• 63,600 points
836 views
0 votes
1 answer

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,600 points
4,433 views
0 votes
1 answer

Excel Formula Help Conditional Formatting - If A2 =TODAY and B2=Y turn A2 Green. If B2 = N turn A2 RED

Create a conditional format rule on A2 ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 63,600 points
603 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP