Conditional Formatting: If, then

[tthebert]

Hi all,

Thanks for all you help on previous posts. I'm a young professional who uses excel often at work and its been very helpful to my development.

I am currently struggling with the shortest way to tackle a project in excel.

There is a set of data I have filtered based on select criteria - consequentially there are rows hidden from the filter. If I were to copy down, it will copy into the hidden rows.

So I'm trying to use conditional formatting to say if there is text (just not blank) in the cell next to it, then make this cell red.

I think I'm on the right track by creating a new formatting rule and then applying the formula, but I'm not sure what the formula would be. Lets call the cell I want to be highlighted x and the cell that must have text in order for x to be highlighted, y.

I want something like =IF(y=NotBlank, x Fill Red, No fill)

I might not be clear here so happy to answer any questions to clear things up if necessary.

Thanks again.

 

[Jonmo1]

In cell x, the formula for conditional formatting would be

=y<>""