Conditional Format Cells Based on Another Cell and Own Cell

Ask a question Elaine - Latest answer on Oct 19, 2016 11:53AM
I'm trying to conditional format cells based on text in another cell and it's own cell.
In Column A, the cells would contain either "hit" or "miss". If the cell is "hit" then nothing needs to be done. If the cell is "miss" then there must be text in the corresponding Column B cell. For example, if A1 is "miss" then B1 must contain text. If B1 doesn't have text, then the cell needs to be highlighted. If B1 does contain text, then no highlights are necessary.
Additionally, is there a way to conditional format this for the entire cell? I have to conditional format for the entire sheet and doing conditional formatting for each row will be too tedious and time consuming.
See more 
moins plus
Select the range of cells in column B
Go into Conditional Formatting.
Select New Rule,
Choose the "Use Formula to determine..." rule
Enter this formula in the Rule Description field.

select the color for the cell.
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!