I need to highlight a cell if the following conditions are not met

**guywheels** · 04-24-2015, 12:36 AM

Hi there,

I need to highlight a cell if the following conditions are not met.
If cell c1 contains a value then cell a1 & b1 should also contain a value. If either cell a1 or b1 do not have a value, then that cell (a1 or b1 or both) must be highlighted

Thanks
Guy

**sktneer** · 04-24-2015, 01:01 AM

Hi,
Welcome to the forum.

To do this.....

Select A1:B1 --> Make a New Rule for conditional formatting using the formula given below and set the format as per your choice.

Please Login or Register  to view this content.

See the attached.

**Nisha Dhawan** · 04-24-2015, 01:28 AM

Hi Guy,

Please use this function =OR(B1="",A1="") in Conditional formatting.

**ashishmehra2010** · 04-24-2015, 01:46 AM

Originally Posted by guywheels

If either cell a1 or b1 do not have a value, then that cell (a1 or b1 or both) must be highlighted

Hi Guy,

Welcome to the forum!

I believe your query contains two questions i.e.

Case1)
If either cell a1 or b1 do not have a value then the blank cell will be highlighted

Case2)
If either cell a1 or b1 do not have a value then both a1 & b1 will get highlighted

Please check the attached file.

Regards,
AM

**sktneer** · 04-24-2015, 04:21 AM

Thanks for the feedback.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

**guywheels** · 04-24-2015, 05:39 AM

Attachment 391103

I hope you can see the image. Here is my problem.
F5 has a number - no action need
I5 no number -needs to be highlighted (if there is a number in L5 or O5)
O8 has a number -I8 & L8 need to be highlighted - don't have a number and need to create a claim

Thank you in advance
Guy

**guywheels** · 04-24-2015, 05:40 AM

Attachment 391103

I hope you can see the image. Here is my problem.
F5 has a number - no action need
I5 no number -needs to be highlighted (if there is a number in L5 or O5)
O8 has a number -I8 & L8 need to be highlighted - don't have a number and need to create a claim

Thank you in advance
Guy

**Nisha Dhawan** · 04-24-2015, 05:51 AM

Hi Guy,

Your attachment is invalid, please check and attach Excel file.

Thanks
Nisha

**Nisha Dhawan** · 04-24-2015, 06:51 AM

Also, please be clear what if I5 has number and F5 does not have any number? which cell will be highlighted???

If I8 or L8 will have number, then which cell will be highlighted. Whether any cell will be highlighted or not?

Please attach a excel file for better understanding and also include the expected result.

Attach A File.jpg

I need to highlight a cell if the following conditions are not met

LinkBack

Thread Tools

Rate This Thread

Display

I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Re: I need to highlight a cell if the following conditions are not met

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Highlight only one Cell in the entire row based on conditions

[SOLVED] highlight row based on multiple conditions

[SOLVED] Highlight another Cell(s) if multiple conditions are ALL met

How Do I Highlight a Cell Based on Conditions of Another?

Highlight row given certain conditions

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions