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.
HansVogelaarI'm hoping you're still active! I'm stuck on a similar conditional formatting issue. I have volunteers' info in columns A:D and I want to strikethrough some of them based on the value in column E. Note that in my real spreadsheet, column E is a VLOOKUP formula that is populating either "Yes" or "No" from a table in a separate sheet. I tried this in conditional formatting based on a formula without success.
="$E$2:$E$6=No" applied to =$A$2:$D$6
Here is a onedrive link with simplified data. No vlookup, but it's still not working. Appreciate any help you can give.
https://1drv.ms/x/c/1b530d0b027a8251/ERWamcXoKn9JmkgsdhvzRHMB_MJ5wVIGfyyvFBMMJjjVWQ?e=LzUdaF
Select A2:D6.
A2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=$E2="No"
Click Format...
Activate the Font tab.
Select the Strikethrough check box.
Click OK, then click OK again.You're a hero!