How to set color validation and mandatory fields in the excel sheet

[kvanoosh]

Hi All,

I was beginner in using excel sheets but have lots of thoughts to implement in them. Can anyone help me in below scenarios ?

A. Need Excel where it has two columns and if any value is entered in a particular row in 1st column then same row of 2nd column should be mandatory.
B. Also, I have 3rd column as "status: which has a dropdown with values as Pass,Fail
status=Pass then total row should change to GREEN.
status=Fail then total row should change to RED.

I think anything is possible in EXCEL. Please help me on this.

Thanks in advance.

Regards,
Anoosh.

[FDibbins]

welcome to the forum. we would be happy to help you, however

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[kvanoosh]

Hi,

COLOR VALIDATION IMPLEMENTATION:
Conditional Formatting>>New Rule>>Use a formula to determine which cells to format
=OR($F3="Cannot Duplicate", $F3="Duplicate")

Based on above the complete row will be colored.

COLOR Only for that cell:
Conditional Formatting>>New Rule>>Format only cells that contain
Cell Value----equal to----Cannot Duplicate

For Mandatory:
Data Validation>>Settings
Allow:Custom
Formula: =NOT(ISBLANK(M3:M199))

Based on the above if M column is blank then corresponding row of another column where formula is written cannot be entered.

Regards,
Anoosh.