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 in Others by Kithuzzz
• 20,660 points
27 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 by narikkadan
• 37,660 points

Related Questions In Others

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,240 points
4,151 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,890 points
1,260 views
0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

Too Many Different Cell Formats

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

answered Oct 28 in Others by narikkadan
• 37,660 points
45 views
0 votes
1 answer

Format an Excel Sheet in Python

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

answered Nov 6 in Others by narikkadan
• 37,660 points
41 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 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 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 in Others by narikkadan
• 37,660 points
172 views
0 votes
1 answer

If Statement Not Working When Including Cells That Have Formulas

Try:  =IF(VALUE(A1)>10;1;0) I hope this helps you. READ MORE

answered Oct 23 in Others by narikkadan
• 37,660 points
47 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