Can someone assist me with this conditional format please?
If there is a name in (B) “Acting” then there must be a date in (c) “Date Acting to” otherwise highlight C cell red.
Regards Kerry:rolleyes:
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Conditional Format if Cell is Blank
Kerry,
Base your conditional format on this formula: [noparse]=AND(B2″”,C2=””)[/noparse].
Note: to enter the formula select all the cells in Column C you want the format to apply to don’t worry it will auto adjust the references.
32920-ConditionalFmt
HTH :cheers:
Kerry,
Here’s a New and Improved set of rules that will check not only if column C is missing a value but also if it contains a number and that that number is a date! This relies on 2 rules.
Rule 1: Check to see if it is a good record e.g. B1 isn’t blank and C1 contains a number that is also a date.
[noparse]=AND(B2″”,CELL(“Format”,C2)=”D4″,ISNUMBER(C2))[/noparse]
You’ll notice from the graphic that this rule sets the color of column C to WHITE since everything is ok and it is also set to stop processing since you need go no further!
Rule 2: Checks to see if B2 isn’t blank if it is it is a bad record since you got past rule 1 so it sets C2 to RED.
[noparse]=C2″”[/noparse]
32922-New-and-Improved-ConditionalFmt
Note: cols D & E were just there to help me work out the logic and are not necessary for the formulas to work.
HTH :cheers:
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.
Notifications