Conditional Formatting when all Fields = TRUE

JohnDadD

New Member
Joined
Apr 17, 2019
Messages
1
I am trying to change the border of a group of fields once all the fields contain the word TRUE. I was trying to set up a formula in Conditional Formatting but I do not know how.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,553
Office Version
365
Platform
MacOS
set a formula in conditional formatting

select the range of cells - if say C2 to D20
then add a formula to conditional formatting =C2
and format to put a border round

that will put a border around the individual cells - not a group
I dont know how to do a group with just a border around the outside
 

Forum statistics

Threads
1,089,164
Messages
5,406,552
Members
403,095
Latest member
cyclingdad

This Week's Hot Topics

Top