Conditional Excel formatting

Asked

Viewed 276 times

1

I have a question and I’d like to know if it’s possible since I’m not getting it.

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

Example: If cell D4 equals "G4" Underlines line X

If cell D4 equals "G6" Underlines line Y

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

excel

  • I think it is not possible using formulas, you would have to build a macro in VBA.

  • build a macro just to show some data to underline?

  • I didn’t want to use Macro because I never studied it. But I see I only have this shape.

1 answer

3


You can make two separate conditional formatting rules:

A3 diferente de 1

A3 igual a 1

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

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.