Conditional Formatting Problum

Closed

Rana - Dec 27, 2015 at 12:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 27, 2015 at 08:08 AM

Hello,

i have excel 2010

i have two rows. a & b
i want if row a cell value not equal b cell value then change color cell b.
(Note this format apply only one cell i want to copy & past down side then pick value of cell A1 not change A2 or A3.
Please Solve this Problem.

Thanks

Conditional Formatting Problum
How to clear formatting in excel - Guide
Phone formatting software for pc - Download - File management
Formatting usb mac - Guide
Code for formatting android phone - Guide
Copy conditional formatting to other cells ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 27, 2015 at 08:08 AM

So from what I am getting is that lets say you have 3 rows populated
R1, R2, and R3

you can to compare a cell in R2 vs a cell in R1 and if not equal apply format to whole row R2

then you want to compare a cell in R3 vs cell in R1 and if not equal apply format to whole row R3

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

What shall i do after formatting my laptop?

Conditional Formatting: 3 range of numbers

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!