Highlight blank cells with condition (another cell contains text)

virtuosok

New Member
Joined
Sep 2, 2020
Messages
43
Office Version
  1. 2016
Platform
  1. Windows
Hi,
I have 3 columns,
E2:E100 - random dates (or blank entries)
F2:F100 - contains formulas which either return # of days between today and a given entry in column E, or FALSE. Formula example =IF(E2>0,TODAY()-E2)
G2:G100 - contains simple numbers, or is blank

How do I apply conditional formatting to highlight any blank cells in column G, if adjacent entry in column F is >7 days? I may need to get rid of FALSE and replace it with empty cells, too, but this is a secondary goal.
 

Attachments

  • Capture.PNG
    Capture.PNG
    7.2 KB · Views: 1

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,114,098
Messages
5,545,946
Members
410,713
Latest member
TaremyLunsil
Top