Conditional Formatting - Adding unwanted characters

Copper Contributor

Adding a very basic set of rules to a spreadsheet but when adding excel changes what i have typed 

From Now()+90

To ="now()+90"

 

Am unsure why as this was working no problem less that a week ago.  

2 Replies

@JB2891 

Prefix with =, i.e.

 

=NOW()+90

*Facepalm* thank you