If formula in cell in addition to using conditional formatting

g8tormjk

New Member
Joined
Jul 9, 2010
Messages
5
Hi-I'm not all that experienced using excel any help would be greatly appreciated:
I'm using an If formula =IF(E$9<$D$9,"Y","N") see screenshot #1 In addition to conditional formatting - see screenshot #2.My problem is I don't want the conditional formatting to "prepopulate" (the green formatting to show) until data is actually in the cell (E10)
 

Attachments

  • Screenshot #1.jpg
    Screenshot #1.jpg
    84.1 KB · Views: 4
  • Screenshot #2.jpg
    Screenshot #2.jpg
    123.7 KB · Views: 4

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,295
Office Version
  1. 365
Platform
  1. Windows
Why not change your formula to
=IF(E$9="","",IF(E$9<$D$9,"Y","N"))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,295
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,337
Messages
5,547,349
Members
410,785
Latest member
phillippaige
Top