To see less ads Register or Login ----- Daily Fantasy Sports games 18+

Conditional formatting help reqd!

A forum to discuss or share knowledge of spreadsheets.
User avatar
Surprised
FISO Jedi Knight
Posts: 26528
Joined: 13 Oct 2005, 18:32
Location: Home
FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4

Re: Conditional formatting help reqd!

Post by Surprised »

Microsoft need to simplify formulas.

It should be as simple as:
"If the date in A is over a year old and there is some paid stuff next to it then make it yellow and if there is eff all in the date bit then don't do shit to it"
Then Excel just does what you want


None of this IF, AND, NOT, ISBLANK rubbish

View Latest: 1 Day View Your posts
Post Reply

Return to “Spreadsheets”