Excel Forum

conditional formatting

Chuck Brancheau

New Member

Members

Forum Posts: 2

Member Since:
August 5, 2022

Offline

October 21, 2022 - 2:36 am

I want to compare the values in column a with values in adjacent cells and format those cells if greater than or less than value in column A

3.84	3.96	4.09	3.67	3.91	4.15
3.69	3.90	3.88	3.67	3.72	4.45
3.87	4.10	4.03	4.00	4.03	4.40
67.73	75.98	73.71	68.11	77.67	85.00
3.63	3.91	3.94	3.89	3.76	4.15
4.35	4.39	4.56	4.35	4.21	4.45
4.36	4.48	4.68	4.30	4.28	4.65
36.27	41.67	45.45	42.86	26.47	60.00

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 441

Member Since:
January 31, 2022

Offline

October 21, 2022 - 2:28 pm

Hi Chuck,

The attached file contains an example with two conditional formatting rules to mark numbers greater (green) or less (red) than the one in column A.

Green: =B1>$A1

Red: =B1<$A1

both applied to $B$1:$F$8

Riny

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Richard West, Kathleen Hayter, Brenda Richards, Shawn Barwick, Nada Perovic

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Forum Stats:

Groups: 3

Forums: 24

Topics: 6218

Posts: 27265

Member Stats:

Guest Posters: 49

Members: 31901

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen