CODEWITHSUNDEEP
excelexcel-formula
Lawliet Lawsford
Lawliet Lawsford

Reputation: 1

Choose biggest value from excel columns and check if condition is matched

I got couple columns that contains number from 1 to 5. After these columns there's column that have some letter. For example:

1 2 3 c
2 2 4 d
4 4 5 d

I need to check if column with letters represent proper letter. It depends on biggest number in first 3 columns.

For example if biggest number in a row is 5, than letter should be 'E' as it's 5th in alphabet. Otherwise I need to change color of the letter.

Could you help me? Thanks

Upvotes: 0

Views: 57

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

Use conditional formatting with a formula like:

=MAX($A1:$C1)+64<>CODE(UPPER($D1))

Applied to Column D

enter image description here

Upvotes: 1

Related Questions