Only show conditional formatting when some of row has been populated

[Helen842000]

Hi all,

Wondering if you could help please. I have 2 worksheets. One is a summary page with slim rows that uses conditional formatting red or clear/blank depending if the corresponding cell on the detailed tab is filled or not. The second contains the comments and is full of text.

The summary tab enables you to see at a quick glance what cells need to be filled in on the 2nd sheet. I'd like to use wording in the if statement so it says EMPTY or FILLED


I want to put conditional formatting in place but only on rows as and when they're populated. E.g I don't want a long list of red cells showing before the row is in use. Or a long list that says EMPTY before the row is in use.

So it should go something like this.

If the Name cell is not populated - stay blank regardless
If the Name cell IS populated show the if/else condition & conditional formatting

Not quite sure how else to describe it! Any suggestions would be greatly appreciated.


So this is how I'd like it to look. Sheet one (summary) - Cond formatting shown in brackets

Number----- Issue Name -------Oct Update -------Nov Update------ Dec Update
1 ----------Broken Router ------FILLED (white) ---EMPTY (red)------ EMPTY (red)
2 --------------------------------(white)----------- (white)----------- (white)


Thanks!

 

[Helen842000]

I guess I could explain it like this in 3 statements..

If both NAME and CORRESPONDING CELL ON TAB2 are blank - cell stays BLANK/EMPTY/WHITE
If NAME contains text and CORRESPONDING CELL ON TAB2 is blank - cell prints EMPTY and turns RED
If both NAME and CORRESPONDING CELL ON TAB2 contains text - cell prints FILLED and stays WHITE

 

[Helen842000]

Or I could shorten it like this

If CORRESPONDING CELL contains any text - cell prints FILLED
If NAME contains text and CORRESPONDING cell is empty - cell prints EMPTY

Then I can just do conditional formatting on FILLED/EMPTY and the rest will be clear.