Forum Discussion
conditional formatting based on content of another cell
Select the cells that you want to format conditionally. If more than one, the top left cell should be the active cell in the selection. Note the address of this cell.
On the Home tab of the ribbon. select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter a formula that evaluates to TRUE (or a non-zero number) if the rule should be applied, and to FALSE (or 0) otherwise.
In your example, let's say A2 is the active cell in the selection.
Use the following formula:
=B2<>""
Click Format...
Activate the Fill tab.
Specify the desired color (green in your example).
Click OK, then click OK again.
If you look closely, you'll see that the formula refers to C2 instead of to C3. You should edit the rule and change the formula to =C3<>"Yes"
HansVogelaar I'm trying to format the D Column to turn green when the whole row from F-K are either complete or N/A. What could I use for the conditional formatting formula? Screenshot attached for reference.
Select D3:D6 (or further down). D3 should be the active cell in the selection.
Use this formula:
=COUNTIF(F3:K3, "Complete")+COUNTIF(F3:K3, "N/A")=6
HansVogelaar I am sorry if I asked a question that you already answered but whatever formula you suggested in the Q&A, it does format the cell as I needed it.
I am trying to create a hiring template and want the candidate's name to appear in Green on the summary page if, on the data page, the candidates salary expectation is entered.
I'd have to see a copy of the workbook (without sensitive/proprietary data)
