Report

Conditional Format Cells Based on Another Cell and Own Cell

Ask a question Elaine - Last answered on Oct 19, 2016 11:53AM
Hi,

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.

Thanks!
See more 
Helpful
+0
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.
=AND($A1="miss",ISBLANK($B1))

select the color for the cell.
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!