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

Excel - IF function with multiple words
Nick -
user -

14 responses
Counting cells containing only numbers
jutulu -
jutulu -

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

26 responses
after starting the laptop screen goes black
kanishhk -
Computertech -

4 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response