View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default UDF to evaluate if row is hidden?

hi -

I'd like to build a UDF to evaluate (true/false) whether a cell is in
a hidden row ... I'll then use this UDF in a conditional format
statement to change the font color of a cell.

As example, I'll have a string in A20 (eg October) ... default font
color is white (aka invisible). However, if cell A19 is hidden (using
outline), then font color of A20 should be black.

I know how to do the conditional format ... but building the UDF is
throwing me off, as I've never built my own. I would image the final
output would be: =IsHidden(A19)

Can anyone help out with this?

TIA,
Ray