• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formating

Hi
I tried to set a conditional formatting but seems doesn't work for me.
See attachment.
I want to set a yellow that contains with text or numbers.
The sample bellow, B and D are blank. When a B or D is being selected in the dropdown box in C5 then it should be no format.

How do I set a conditional format with text and numbers that contains only.

Thanks
 

Attachments

  • conditionalformat.xlsx
    9.8 KB · Views: 3
Select E4 >> Conditional Formatting
>> New Rule
>> Choose "Format only cells that contain"
>> select "No Blanks" from the rule box dropdown list,
then,
click "Format" choose yellow background color
>> OK
>> Finish

66876
 
Hi Thank you.
I added a border but it only border color one cell and not the entire cells merged.
see attachment.

Thank you again
 

Attachments

  • conditionalformat.xlsx
    11.8 KB · Views: 3
Oooops.... : o(
How did you attach an image in your reply? Sorry, I am kinda new here. It was cool the way you do it.

Thank you
 
Back
Top