Previous Topic Next Topic

Color cell

Closed
docheller Posts 1 Registration date Friday April 5, 2019 Status Member Last seen April 5, 2019 - Apr 5, 2019 at 12:20 PM
 Blocked Profile - Apr 5, 2019 at 01:09 PM
Hello,
I have this formula to place a date in cell when negative number.

=IF(D14<=-1,TODAY(),"")

I would like to add to the formula to change the cell color when there is a date present.

any help would be appreciated.

1 response

Answer 1 / 1
Blocked Profile
Updated on Apr 5, 2019 at 01:11 PM
Take a look here.

0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Connecting IO Box to Switch without Patch Pan
Vikas Yadav -
chandrakant -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses