Excel Conditional Formatting

1

I have a question and I would like to know if it is possible since I am not able to.

I have a cell that shows me a result (Cell D4) And I want the result to underline two lines.

Example: If cell D4 is equal to "G4" Underline line X

If cell D4 is equal to "G6" Underline line Y

I've put this rule and it's not working: = SE ($ D $ 4="G $"; "")

    
asked by anonymous 14.07.2014 / 16:00

1 answer

3

You can make two separate conditional formatting rules:

In your case, replace =$A$3<>1 and =$A$3=1 with =$D$4=$G$4 and =$D$4=$G$6

    
15.07.2014 / 05:43