Conditional Format Cells Based on Another Cell and Own Cell
Closed
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!
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!
Related:
- Conditional Format Cells Based on Another Cell and Own Cell
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Based on the values in cells b77 b88 - Excel Forum