cell formatted for current day
 

How do i use cond formatting to highlight cell that are
empty or filled to have a filled backgraound when it is
on current day?
(the cell above a row that is date value?)

row 3 is date value and column g thru ab is cells to be
filled in daily. i haveit set up to highlight the date
value to be grey on current day. i seem to get errors
wheni try to do just cells with no value.

cell formatted for current day
 

Hi
enter the following formula for your row 4 (lets say for cell G4):
=G3=TODAY()

--
Regards
Frank Kabel
Frankfurt, Germany

mkbr wrote:
How do i use cond formatting to highlight cell that are
empty or filled to have a filled backgraound when it is
on current day?
(the cell above a row that is date value?)

row 3 is date value and column g thru ab is cells to be
filled in daily. i haveit set up to highlight the date
value to be grey on current day. i seem to get errors
wheni try to do just cells with no value.