Conditional Formatting Question

[trekker6000]

I am wondering how I could use the IF formula to create a conditional formatting rule that would highlight rows that are "unresolved" (an empty cell in the row). Basically, I have a spreadsheet that is documenting cases of unresolved credit cards being sent back to their respective departments so that they can reach out to the customer, resolve the issue, and send the corrected information back to me. If it is resolved, we date the column in question which would remove the highlighting across the cell that indicated an unresolved case. Any direction on this? I can take some screenshots if necessary.

Thanks!

 

[Ian Bertie]

I am wondering how I could use the IF formula to create a conditional formatting rule that would highlight rows that are "unresolved" (an empty cell in the row). Basically, I have a spreadsheet that is documenting cases of unresolved credit cards being sent back to their respective departments so that they can reach out to the customer, resolve the issue, and send the corrected information back to me. If it is resolved, we date the column in question which would remove the highlighting across the cell that indicated an unresolved case. Any direction on this? I can take some screenshots if necessary.

Thanks!

Which version of Excel as 2013 has a conditional format to fill blank cells

 

[Mike LH]

Hi,

Conditional formatting is just the tool for that. Let's say that column G is the cell we're testing for resolved and if it empty we want to shade the row and this starts in row 2.

Select A2 then drag across to select as many columns as you want then drag down for as many rows as you want then

Home tab | Conditional formatting | New rule | Use a formula to decide which cells to format and enter this formula

=$G2=""

Click the format button | fill tab and choose a colour and OK out.


If you change the column in the formula from G be careful to keep the $ sign before the column.