I would like to show an asterisk in a cell for 48hrs (eg. tentative booking) . The date is in cell A. Asterisk will be in cell B. I would also like to keep this asterisk there only if there is no tick in another cell eg. payment not made..

How about; when I tick that a deposit has been paid, how can I change the whole line to red so that I know it is a confirmed booking.

Hi Wendy,

Glad to hear things are working out on your end. I was afraid with all the formula frustrations that you had been scared away from Numbers for good.🙂

What you are talking about here is something that in Numbers is called "conditional highlighting".

To set up conditional formatting so it will work with Numbers documents on your iPad you need access to the latest (free for most people) version of Numbers (3.0) on a Mac. You select the cells and format them with rules like this (in the right panel after you select cells you want to format, click the "paintbrush" format icon, and then the "cell" tab.)

Then when you sync the document back to your iPad the conditional formatting you set up on the Mac will still work. (Conditional formating doesn't work when you look at your document in Numbers for iCloud, though it's "still there" the next time you look at the document on the iPad or Mac. In previous versions the formatting used to just mysteriously disappear if you edited on the iPad or in iCloud.)

Unfortunately, this will highlight only the cells with the rules in them, not the entire row as you want. The rules don't apply to cells other than the ones that contain a rule. But this may give you some ideas for visual cues that you can use. In addition to the "fill" (pictured here) you can control the font size, color, style, etc.

SG