LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 24th 19, 01:15 PM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: May 2015
Posts: 13
Default Check row for conditional formatting (color)


My worksheet has 20 columns, each of which (except column A) has some
sort of conditional formatting to look for certain criteria. I'd like
to add conditional formatting to column A to return True (and thus
highlight) should ANY of the other 19 columns be conditionally
formatted (i.e., find something). I haven't been able to figure out
the best and easiest way to do that. I'd appreciate any thoughts and
advice. Thank you.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
check text color from conditional formatting w/out using VB slinger Excel Discussion (Misc queries) 3 November 10th 06 06:58 PM
conditional formatting via check box cedtech23[_13_] Excel Programming 1 July 20th 06 04:19 AM
Conditional color formatting entries have wild color. John Geyer Excel Discussion (Misc queries) 0 February 24th 06 06:11 PM
Check box & conditional formatting Brent Excel Discussion (Misc queries) 4 January 10th 06 05:43 AM

All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017