Identify cell that don t contain formula

0 votes

version: Excel 2010

Is there a way to quickly identify or create a simple macro to identify cells that don't have a formula?

--------------------------------
|=A1*1 |   151 | =A3*1 | =A4*1 |
--------------------------------
|=B1*1 | =B2*1 |   100 | =B4*1 | 
--------------------------------

Quickly highlight or change the font color of cells 151 and 100.

Dec 11, 2022 in Others by Kithuzzz
• 38,000 points
827 views

1 answer to this question.

0 votes

Select the range you wish to test, press Ctrl+G, and then click Special to complete the task quickly and easily without using VBA.

When you specify the cell type you desire and click OK, only those cell types will continue to be selected. To pick all cells in your situation that don't have formulae, choose Constants.

image

answered Dec 11, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Flutter Error: MediaQuery.of() called with a context that does not contain a MediaQuery.

Hi@akhtar, You need a MaterialApp or a WidgetsApp around your widget. They ...READ MORE

answered Aug 27, 2020 in Others by MD
• 95,460 points
5,130 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

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

Excel formula to get cell color

Add a Name(any valid name) in Excel's ...READ MORE

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

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,600 points
1,534 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,740 points
1,225 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,020 points
1,101 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,020 points
4,383 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,271 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
3,746 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