formatting left cell on basis of write cell

[lalit18276]

Please tell

if B1 =LFU than A1 fill red
if B1 =Active than A1 fill green
if B1 =Death than A1 fill black

[benishiryo]

welcome to the forum, lalit. select the range you want to apply to (say from A1:A10)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=B1="LFU"
format red

repeat the steps & just change the text & colour accordingly

[taccoo73]

Home Tab>Conditional Formatting>New Rule

Under Select Rule Type, chose "Use a formula to determine which cells to format" option. Under "Format values where this formula is true" put the following;

=(B1)="LFU"

Click on "Format" button, go to "Fill" tab and pick your color.

Repeat the procedure for the other two options. For active, replace "LFU" with "Active" and pick another color, and so on..

Hope this helps.

tac

[lalit18276]

Thanks very much it worked

[lalit18276]

How to calculate the current age if Date of registration and age at the registration given trying below but not getting, what should be at .........

=(IF(AND(D7<>"",H7<>""),MAX(((.............-H7)/365)+D7,D7),""))