I have searched the forum and the internet, but all I have found is conditional formatting which does not appear to do what I want. I have a column into which either a "Y" or "N" will be placed and if "Y" I would like a highlight of the adjacent cell as a reminder for me to do a follow up.
Right now I am using a simple =IF(h2="n","-"," ") to auto fill a dash in the adjacent field as there is nothing left for me to do, but by leaving blank, it is hard sometimes within the sea of data on the page to quickly identify the items that need a follow up. Wanted to make it highlight so that it really stands out.
Looking for something like =IF(H2="n","-",highlight cell red), but can't figure out the RGB code or whatever I need to input to get the color. I may be going about it entirely wrong, so coming to you guys for help again.
Any help is greatly appreciated. Thanks.
Edit: not sure if it matters, but want to do it this way so that once I do my follow up... I will be entering a Y in that field which will replace the formula, therefore, removing the highlight.
Right now I am using a simple =IF(h2="n","-"," ") to auto fill a dash in the adjacent field as there is nothing left for me to do, but by leaving blank, it is hard sometimes within the sea of data on the page to quickly identify the items that need a follow up. Wanted to make it highlight so that it really stands out.
Looking for something like =IF(H2="n","-",highlight cell red), but can't figure out the RGB code or whatever I need to input to get the color. I may be going about it entirely wrong, so coming to you guys for help again.
Any help is greatly appreciated. Thanks.
Edit: not sure if it matters, but want to do it this way so that once I do my follow up... I will be entering a Y in that field which will replace the formula, therefore, removing the highlight.
Last edited:
