Forum Discussion

SeanC3's avatar
SeanC3
Copper Contributor
Oct 20, 2021

Excel Formula Help - Conditional Formatting a cell based on specific text in two other cells

Hi team,

 

I am hoping someone can assist in figuring out a formula that will allow me to quickly audit a large amount of data.

Ideally I need to conditional format a cell (C1) only if (A1) contains "HOME" and (B1) contains any letters, or alternatively, if cell (A1) contains "AWAY" and (B1) does not contain a letter.

- any cell in column (A) with "HOME" should have only numbers in column (B)

- any cell in column (A) with "AWAY" should have a mix of numbers and letters in column (B)

All discrepancies I need to highlight so we can identify and correct

 

I have attached an example of ideally what I need, but if anyone has a formula that would work or has a work-around I would appreciated the assistance.

Thanks, Sean

1 Reply

Resources