Conditional formatting

Cquake

Board Regular
Joined
Dec 12, 2017
Messages
53
I am pulling data from a vlookup function which does allow me to pull the color formatting. With that being said I have positive results which are in green, negative results in red, a QT entry also in red, a QR in white, 0 (zeros) in white and PEN with a plus sign and number. The data will change for each team pulled up.

when I pull that data from the vlookup into the cells is there a way to use conditional formatting to accomplish color coding them? Any help would be appreciated. There are 3 seperate team data areasthat have 39 rows down and 9colums across.
Team data area are named offense, defense and special teams
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,957
Office Version
  1. 365
Platform
  1. Windows
Excel functions (such as VLOOKUP) can only return values, not any formatting from the source field.
However, you can set up the same Conditional Formatting logic that is applied to the original data so that what is returned matches the format of the original data.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,047
Messages
5,599,497
Members
414,315
Latest member
Yolanda5050

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top