Hi
is it possible to set the conditional formatting int he following scenario :
Cell A2 has a specific date
so in B2 if user put any value before or after the date in Cell A2 then Cell C2 turns Red ?
thanks
Hi
is it possible to set the conditional formatting int he following scenario :
Cell A2 has a specific date
so in B2 if user put any value before or after the date in Cell A2 then Cell C2 turns Red ?
thanks
CF cell C2 with formula =A2<>B2
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks TMS
but in Cell B2 doesn't have any date or numbers, it has users name
I don't understand ...so in B2 if user put any value before or after the date in Cell A2 then Cell C2 turns Red ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks