With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, June 12, 2017
yogi_Conditionally Format Cells E7 To EY33 If Entry In Column E is 'Complete' and Entry In Column F Through EY is 'X'
I would like to apply a set of conditional formatting logic across a group of cells, but have the rows and cell numbers change based on the cell that I "drag/copy" the conditional formatting to.
To be clear, I would essentially like the conditional formatting logic with the following formula...
=AND(E7="some text",K7="some other text")
...To be applied to a large number of cells. But I cannot just apply the above formula to all cells, I need the rows and cell values formula to change dynamically based on each cell that I apply it to (as if I had dragged a normal formula across a group of cells).
To be clear again, I need the above formula to change to =AND(E8="some text", K8="some other text") and =AND(E7="some text",L8="some other text") when I apply it to different rows and columns.