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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,247
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,247
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,261
Messages
5,546,832
Members
410,759
Latest member
Bufnercash
Top