View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Feeta Feeta is offline
external usenet poster
 
Posts: 2
Default set "value if true" to "fill cell with color"

I want to use an IF statement to check for text in a cell range and if true,
then fill a cell with a highlight color. In my application, I would look for
"PD" in invoice date fields and if found, highlight the amount invoiced in
green. I don't know the snytax to write the return value as "fill this cell
with color".