Hello Excel gurus out there! I'm looking for a way to change the font size of a cell K3 based on the text value of cell O3. If cell O3 has the word 'Written' in it, the font size in K3 would be 22. If cell O3 has any other value, then the font size in O3 would be 12. This formula would be true for any row in the sheet (20,000 rows). Ideally it would happen automatically but running a macro that checks a selection of rows would also work.
Thank you for any help or advice on this task. I've been banging my head on it for a while now.
Cheers!
Bookmarks