Conditional formatting

MCB1973

New Member
Joined
Jun 12, 2023
Messages
10
Office Version
  1. 365
Platform
  1. Windows
Hi All,

i need some help please, what i need to do is when a number is entered into Col G, i need Col A to change color, BUT the issue I have is the data is floating in COL C-F, so this changed depending on the event registered, this there any way to change the color in COL C if it moves a line with out changing the fixed data in COL G, any help would be appreciated.



C D E F G
1687821951502.png
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
its reasonably easy to do the first part

but i dont know what this means
so this changed depending on the event registered, this there any way to change the color in COL C if it moves a line with out changing the fixed data in COL G, any help would be appreciated.
whats the event registered ????
If what moves a Line ????

it sounds a bit like you need VBA , BUT i'm not sure if that the case , and i dont supply VBA solutions

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(G2 <> "" )

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book9
ABCDEFG
1header1header2
2
3
4a
5
6
7
8b
9
10
11c
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:A20Expression=G2<>""textNO


Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore -

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

You can also test to see if it works ok, in the "Test Here" forum.

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone
 
Upvote 0
its reasonably easy to do the first part

but i dont know what this means

whats the event registered ????
If what moves a Line ????

it sounds a bit like you need VBA , BUT i'm not sure if that the case , and i dont supply VBA solutions

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(G2 <> "" )

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book9
ABCDEFG
1header1header2
2
3
4a
5
6
7
8b
9
10
11c
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:A20Expression=G2<>""textNO


Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore -

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

You can also test to see if it works ok, in the "Test Here" forum.

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone
ok due to restrictions on a work PC i am unable to install the add on, it just wont allow it and they have us locked down fairly tight, i can please a copy of the sheet with all data removed with test lines in it, if you could send me a private message with a share email im am more than happy to get it yo you this way.

Thanks
 
Upvote 0
are you able just to put onto the share for everyone to see here , taking it off line is not allowed on the rules - it enables others to answer, and also to sme extent check on whats being suggested - sort of peer review , so any mistakes or better ways can be seen by all

As its
i can please a copy of the sheet with all data removed with test lines in it,
then should be ok on a share, as i suggested
 
Upvote 0
are you able just to put onto the share for everyone to see here , taking it off line is not allowed on the rules - it enables others to answer, and also to sme extent check on whats being suggested - sort of peer review , so any mistakes or better ways can be seen by all

As its

then should be ok on a share, as i suggested
 
Upvote 0
are you able just to put onto the share for everyone to see here , taking it off line is not allowed on the rules - it enables others to answer, and also to sme extent check on whats being suggested - sort of peer review , so any mistakes or better ways can be seen by all

As its

then should be ok on a share, as i suggested
Q. how can i upload a share file on here, only new to this site... as per previous unable to add any extras in
are you able just to put onto the share for everyone to see here , taking it off line is not allowed on the rules - it enables others to answer, and also to sme extent check on whats being suggested - sort of peer review , so any mistakes or better ways can be seen by all

As its

then should be ok on a share, as i suggested
could you assist me with how to upload a share file, new here and unsure where to go...
 
Upvote 0
this site does not allow files to be uploaded
so you have to use another site which allows sharing - like dropbox onedrive or googledrive or use google docs
do you have an account on onedrive, dropbox
you upload onto those cloud services and then you can right click on the file and share

onedrive

similar with dropbox

I cannot pm you , you may not have been here long enough or have enough posts
 
Upvote 0
this site does not allow files to be uploaded
so you have to use another site which allows sharing - like dropbox onedrive or googledrive or use google docs
do you have an account on onedrive, dropbox
you upload onto those cloud services and then you can right click on the file and share

onedrive

similar with dropbox

I cannot pm you , you may not have been here long enough or have enough posts
 
Upvote 0
you need to grant access to everyone
i cannot open,
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

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
Back
Top